Posts by felower

  • vba word to excel

    I have converted a PDF file to Word (I have found that Word is the most accurate conversion).
    The idea is to be able to transfer the Product #, Qty, and Price. from the Word document to excel. I usually have monthly reports of 40 to 75 pages long. where I need to gather the product, Qty, And price
    I'm doing it manually and is taking me a long time to do it.
    I have an item list database, I was think of using my product list data base and formulate some sort of Vlookup...

    but I was doing more research and it looks like my best option would be Vba.

    here is an example of how my file looks like

    0047715000038616 E199.25CMOOROSCO AUSTDISDNNOS(878)686512500
    0883201/09/20169009 NE 54TH STVANGLADASWA 98662
    00029958 F199.25PINTER DAN(319)977-4864
    0512801/11/20162513 SUMMERWOOD CT SWCEDAR RAPIDSIA 52404
    00122723 C1859.25WHITE KIMUEL(907)202-1699
    0527801/06/2016NC 99515
    00126474 F187.25ESPOSITO ANTHONY(702)999-5070
    0714401/06/20166345 N BLVD APT BOSTONMA 90027
    00071920 F178.25(786)483-5124
    0125901/06/20165055 NW 65ND CT APT 264NEVADANV 33137
    00137696 E158.25THOMAS WALTER(404)398-3691
    0994801/06/20168956 **** CREEK RDALPHABLONDYGA 30022
    00265930 C158.25HOMER ALEXANDER(605)933-3636
    0921001/11/20169874 N KRAVIS AVEBIOUX FALLSBB 57107
    00005759 E158.25GUERRA JOE(432)895-8065
    0230901/11/20165897 BRAZOS AVEODENASTATX 79764
    154.00



    WebTON
    477184 1MR VORTEX-SOUR WATERMELO$3.3012/07/201512/30/201526.600.667.26
    477120 84$4.00V/02/201512/04/201s28.000.808.80
    477135 NITE-BURN$4.3712/01/201512/30/20151356.815.6862.51
    477137 30 DAY MUSCLE SCULPTING STACK$7.5012/03/201512/30/201s215.001.503.650
    477149 BEST BCAA FRUIT PUNCH$3.5012/02/201512/03/2015310.501.0531.55
    477150 BEST BCAA WATERMELON ICE$3.5012/28/201512/28/201513.500.353.85
    477157 1MR VORTEX-FRUIT PUNCH$3.3012/10/201512/10/201513.300.333.63
    477177 LEAN, HARD,& SHREDDED STACK 2$7.0012/28/203512/28/2015214.001.4015.40
    477191 84575012/02/201512/29/2015215.001.501650
    477249 BEST AMINOS W/ENERGY HRCN 0$4.0012/16/201512/16/201514.000.404.40
    477250 BEST BCAA PASSION FRUIT$3.5012/02/201512/03/201527.000.707.70
    477252 BEST GLUTAMINE BERRY CITRUS$3.0012/09/201512/27/201539.000.909.90
    477253 CREATINE HD UNFLAVORED$4.0012/30/201512/30/201514.000.404.40
    477254 CREATINE RED SNOW CONE$4.0012/22/201512/22/201514.000.404.40
    477163 1MR VORTEX-BLUE LEMON ICE$3.3012/09/20Bi2/09/203513.300.333.63
    37USD$180.43



    VENDOR: GNC 000004770 BPI SPORTS

    ITEM PRODUCTVENDOR PAIDQTY.PROMO AMT.KICKER
    AMT.    		VENDOR AMOUNT
    00477000 ROXYLEAN BONUSYES100%47187.21.00187.21
    00477002 A-HDYES100%25111.54.00111.54
    00477003 SOLIDYES100%14.95.004.95
    622.88.0022.88
    00477067 1MR WATERMELON BONUSYES100k415.18.0015.18
    00477069 1MR PINK LEMONADEYES100127.48.007.48
    00477070 1MR CHERRY LIMEYES100'415.18.0015.18
    00477072 1MR BLUE RASPBERRYYES100127.48.007.48
    00477074 BUILD-HD FPYES100k13.63.003.63
    00477075 BUILD-HD VTR MELYES100128.25.008.25
    00477076 BUILD-HD WHITE RASPYES100%12.20.002.20



    PROGRAM: AM0065B - AMWP0065 - STEP0010
    VENDOR: 004770 BPI SPORTS    		GENERAL NUTRITION, INC. PAGE: 1
    PAY ON SCAN SYSTEM RUN DATE: 01/13/2016 RUN TIME: 06:02:01 VENDOR INVOICE DETAIL REPORT
    ACTIVITY FROM 01/07/16 THRU 01/13/16
    AP VENDOR: 000004770

    INVOICE REFERENCE NUMBER: POS011316 INVOICE DATE: 01/13/2016





    as you can see within the file I have more than one format

    So the idea is to be able transfer the info in to a excel table with product #, Qty, price

    Im not an expert on VBA and I'm good with formulas on excel

    but any help would be greatly appreciated