Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy contents of formfields from word to excel (Word 2000)

    Merry Christmas everyone!!

    I'm looking for a macro that will copy the content of all the formfields in a several word documents to an excel file.

    Thanks for all your help in the past.

    dan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy contents of formfields from word to excel (Word 2000)

    > in a several word documents

    Do you want the macro to loop through ALL documents in a folder, or do you want the user to be able to select individual documents?

    How would you like the data in the workbook to be organized? Do you want only the values of the form fields, or the names and the values? Do you want a separate worksheet for each document, or should everything be in a single worksheet? If the latter, do you need the name of the document too? Please provide specific information.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy contents of formfields from word to excel (Word 2000)

    Hans,

    Names and values on a single worksheet. I don't need the name of the document. I would like to be able to pick the documents to be used.

    Thanks,

    Dan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy contents of formfields from word to excel (Word 2000)

    I hadn't noticed that you're still on Word 2000, which doesn't have a file picker. The attached code will loop through all files in a folder, so you'll have to move or copy the files to a folder.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy contents of formfields from word to excel (Word 2000)

    Thanks

Posting Permissions

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