Run-time error '1004' when trying to export data from Word to Excel.

**msmithy** · 11-20-2013, 06:08 AM

Hi Everyone,

I have set up a word template that when an update button is pressed draws information from an Excel worksheet to place holders in the word document. However each time I run the code I get an error "run-time error '100', which then asks me to check the document's path and/or delet the Excel sheet from my recent documents.

I have checked the path and deleted all recent documents but this error still occurs. Could this error be from running an Excel document that is macro enabled? If so could anyone prvide code to over come this problem.

My current code is below:

Please Login or Register  to view this content.

**macropod** · 11-20-2013, 06:49 PM

If the data always come from the same Excel cell, simply copy the Excel range, then paste it into your template using Paste Special with the 'paste link' option and the data format you require. Then, whenever you create a new document from the template, simply update the links, using .Fields.Update. You can then unlink the data using .Fields.Unlink. That way, there's no need to automate Excel or open the workbook.

**msmithy** · 11-21-2013, 05:33 AM

so my code would look like this?

Please Login or Register  to view this content.

Or do I need to take out the path of my document?

**macropod** · 11-22-2013, 02:18 AM

No, you field could be no more than:

Please Login or Register  to view this content.

If, however, there was a possibility that you'd want to refer to a different range, a different worksheet, or a different workbook, you would need to modify the field code first. That, too, is quite easy to do in vba without ever automating Excel.

Run-time error '1004' when trying to export data from Word to Excel.

LinkBack

Thread Tools

Rate This Thread

Display

Run-time error '1004' when trying to export data from Word to Excel.

Re: Run-time error '1004' when trying to export data from Word to Excel.

Re: Run-time error '1004' when trying to export data from Word to Excel.

Re: Run-time error '1004' when trying to export data from Word to Excel.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Chart.Export error '1004' after upgrade to Excel 2003

[SOLVED] Run-time error '1004'; Method 'Export' of object'_Chart' failed

ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method

[SOLVED] excel chart export error runtime 1004

[SOLVED] excel chart export error runtime 1004

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions