word to excel

  1. M

    VBA Code Needed For Word to Excel

    Hello all, Excel 2013 & Word 2013. I have a directory full of .doc files. Let's call it C:\BOM. I will generate a .txt file of certain files from that directory and save it as C:\BOM\BOM.txt. Example: BOM.txtC:\BOM\file01.doc C:\BOM\file05.doc C:\BOM\file11.doc C:\BOM\file47.doc I need an...
  2. H

    Microsoft Word data to Excel Columns

    Is it possible at all to cut the first top 5 lines in a Word Document and have them send over to an Excel table? Word Data: ALL100 ALL RECREATION 1111 LAYES DRIVE BURNSVILLE...
  3. R

    Transfer Data from Word to Excel with VBA

    Hi team, I am chasing some help on this one. I have a word document template with Text Form Fields where data is to be put. I am trying to set it up so that when these fields are filled out in work, you can press a button and the information gets transferred into a related table in excel...
  4. A

    Word Pages to Excel Sheets

    Hello Everyone, I am wondering if it is possible to use a macro to copy a word page to an excel sheet. For example word document has 45 pages, and when we start the macro, excel will have 45 sheets. It is not important for excel sheets to have the page numbers of word document. I searched the...
  5. J

    structured data export word to excel via vba - optimisation opinion

    Hello everyone, i would like your opinion on the following: I need to extract data from several word documents (about 80 pages each). These documents have somewhat of a standard formatting that enables the structured extraction. Example: word in upper case in document will go to column B...
  6. A

    Word Pages to Excel Sheets Macro

    Hi Guys, I am working on word documents that has financial numbers on them. I am copying word pages to excel to calculate the numbers by using formulas and etc. I will cut to the chase; is there a way or a macro to insert into an excel template workbook(.xltx) when we open the template there...
  7. G

    help: converting wor to excel

    hi i have this word document that i need to put it in excel sheet i put a sample for what i need from the word and how i need it to be in excel Uploaded with ImageShack.us and here is sample of how i need it in excel Uploaded with ImageShack.us i also uploaded the word document...
  8. G

    Again: word document to excel

    Hi i have this word document with repetition pattern i need to convert it to excel. i had this problem before and it was solved by rosenbe here http://www.mrexcel.com/forum/showthread.php?t=594601 and now i have very much similar file need converting the same way, so i tried to alternate the...
  9. G

    word document to excel

    greetings everybody i have searched the forum for a solution to my problem but no luck. so, I'm pleading for help. i have more than 200 pages in doc i need to convert id in a table in excel here is a sample for only 4 items (entries) (i.e. rows) I made an excel for the first for to show you...
  10. T

    How Do I Late Bind This...

    Hey all! I was wondering if anyone knew copy range G15:H600 from excel to word, paste it, and then copy it back from word to excel in the exact same location from whence it came - all using late binding. I've been trying everything I can think of, but I have very little experience in this...
  11. C

    Passing values from Excel To Word and reflect values in Word different places of page/pages

    Hi All, Thanks in advance,I'm a complete newbie when it comes to VBA programming, Excel and Word other than the most basic of use. I have a word document which I would like to automatically populate data from Excel into. The word document is a template and I would rather the data from excel...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top