Results 1 to 3 of 3

Error with macro to open Word doc and copy fields

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Error with macro to open Word doc and copy fields

    Hi all,

    I have a macro to go to a specific folder on my shared drive, open the Word documents (forms that are filled out by other users) in that folder (Unprocessed), pull the data from it and insert it into the appropriate field - then, close the Word document and move it to another folder on the shared drive (Processed). This was all working great yesterday, now I keep getting and error at the line:

    wdApp.Documents.Open (fsFile)

    Can anyone help? I have attached a copy of my spreadsheet w/ macro and the template for the Word form.

    TIA
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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