Page 2 of 2 FirstFirst 1 2
Results 11 to 15 of 15

Thread: Help with VBA to extract data from Word to Excel

  1. #11
    Neophyte lolla1970's Avatar
    Join Date
    Jul 2019
    Posts
    4
    Articles
    0
    Excel Version
    16


    Register for a FREE account, and/
    or Log in to avoid these ads!

    When I run the macro the pop window only let me choose the folder path and not the files

  2. #12
    Neophyte lolla1970's Avatar
    Join Date
    Jul 2019
    Posts
    4
    Articles
    0
    Excel Version
    16
    It work sorry I was missing it. It works now. Thank you

  3. #13
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    39
    Articles
    0
    Excel Version
    2010
    The code is for choosing the folder. All documents in that folder are processed. If you want to process only a limited number of documents, then make sure they're the only documents in the folder.
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  4. #14
    Neophyte Greyness's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    19
    I am trying to do "Word to Excel" with all datas and images. When I try to use this code, I got a error message "Method or data member not found" on "Sub GetTableData()". Then I figured it out that "With .Tables(t)" causes this error. How can I solve it, can you help me?

  5. #15
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    39
    Articles
    0
    Excel Version
    2010
    The code I posted, which doesn't use "With .Tables(t)", works just fine...
    Cheers,
    Paul Edstein
    [MS MVP - Word]

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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