+ Reply to Thread
Results 1 to 4 of 4

macro to take data from tables in word file to excel file

Hybrid View

  1. #1
    Registered User
    Join Date
    09-23-2009
    Location
    liverpool, england
    MS-Off Ver
    Excel 2003
    Posts
    78

    macro to take data from tables in word file to excel file

    Hello

    I was after a little help if possible.

    The macro I am trying to make will take data from the word file “606letter practice” and then update the excel file “practice pocva”.

    The word file is a template letter that gets updated with new generated information. What I want it to do is take selected information and then update the next available line.

    In the word file, table 2, row 1 column 2, data should be inputted in the next available line on excel file column 1

    Table 1 row 3 column 3 – inputted to column 2 excel

    table 3 row 2 column 1- input column 3 excel with the word “list”

    table 3 row 5 columm 1 input column 3 excel with the word “ISAC”

    table 3 row 8 column 1 input column 3 excel with the word “ISAA”


    I hope this all makes sense , any questions please ask, and any help really would be appreciated. I have attached a mock up with a before and after.

    kind regards

    Joe
    Attached Files Attached Files
    Last edited by sandbach; 12-07-2010 at 12:18 PM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: macro to take data from tables in word file to excel file

    Are you looking for help with programming, because you posted your question in this subforum ? I can't see any programming of yours in the files you attached.



  3. #3
    Registered User
    Join Date
    09-23-2009
    Location
    liverpool, england
    MS-Off Ver
    Excel 2003
    Posts
    78

    Re: macro to take data from tables in word file to excel file

    yeah, im looking to add a macro to the dummy files.

  4. #4
    Registered User
    Join Date
    09-23-2009
    Location
    liverpool, england
    MS-Off Ver
    Excel 2003
    Posts
    78

    Re: macro to take data from tables in word file to excel file

    bump i have amended the original post for simplicity.

    Please can anyone help?

    I am totally stuck with this!


    Kind regards

    Joe

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1