Hello once again
This time I have an Excel workbook that when the user fills out information on a user form, the data is placed on a worksheet and exported to Word as a table. So far, so good. There is an additional user form to update existing records on the worksheet. Once finished VB updates the worksheet and then opens the related Word document, again for updating.
The Word document is opening but my error message is fired that says "No tables found", even though there is one there. This is where the system falls over.
I've tried several methods of getting the document opened, updated, and saved. None have worked so far. The code that follows is the portion used to open the Word document after updating Excel. Until I learn how to directly edit the Word document, the table values are supposed to be copied back to Excel and then re-exported with the updated information.
If someone is interested in looking through the entire workbook, I can upload it. All of the file paths and document names would need to be modified in order to run the routines.
Please Login or Register to view this content.
Bookmarks