+ Reply to Thread
Results 1 to 4 of 4

Importing data from a Word 2010 form to Excel 2010.

  1. 06-16-2011, 07:58 AM #1
    mlang
    mlang is offline
    Registered User
    Join Date
    06-15-2011
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Importing data from a Word 2010 form to Excel 2010.

    Hi,
    My question is very similar to post: http://excel.bigresource.com/Track/excel-qh8tFqoE/

    I have excatly the same problem as mentioned above. I have very little experience with VBA, so you have to excuse me for asking obvious questions. The solution provided by Marble2009 doesn't work when I apply it on a Office 2010 computer.
    Application.FileSearch is not used in Office 2010 (as far as I could read), and there might be other problems.

    What I need is the following: multiple Word 2010 forms (docx) -> txt -> 1 excel spreadsheet.

    I guess I need help on how to update the code to Office 2010.

    Best regards,
    mlang
    Reply With QuoteRegister To Reply
  2. 06-16-2011, 08:16 AM #2
    Domski
    Domski is offline
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Importing data from a Word 2010 form to Excel 2010.

    This is some code I wrote the other day to retrieve info from form fields on word docs saved in a particular folder which avoids using filesearch. It may be of use to you:

    Please Login or Register  to view this content.

    You will need to set references to the Miscrosoft Forms and Microsoft Word object libraries in the Excel VBA editor.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  3. 06-19-2011, 06:14 PM #3
    mlang
    mlang is offline
    Registered User
    Join Date
    06-15-2011
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Importing data from a Word 2010 form to Excel 2010.

    Hi,
    Thanks a lot. I will giver this a go as soon as possible.

    Best regards,
    mlang
    Reply With QuoteRegister To Reply
  4. 07-16-2012, 08:55 AM #4
    trish556
    trish556 is offline
    Registered User
    Join Date
    07-02-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Importing data from a Word 2010 form to Excel 2010.

    Hi Dom,
    Are there any updates to the file since you've originally posted it?
    Thanks,
    Tricia
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1