Exporting excel data to word template

Hello there
Could you post a sample of the report and the spreadsheet, and we can throw some code together to make them talk. No sensitive info, just the skeleton of the templates.

Regards

report1.xlsTemplate.doc

Hello
There are a couple things to get this working. The VBA actually sits in Word and goes out to fetch the data to plug back into the template.

In Word there are 2 controls inserted, the 1 is a label and the other is a button. The label is the placeholder for the data while the button runs the VBA and gets the data.

Tips : be careful that the file location is correct, that the cell position is right. To change existing controls or add new ones, you need to go to "Developer" tab and select "Design mode". The controls are in "legacy tools" just below the Design mode

Have a look and see if you can extent to the rest of the data fields. I renamed the spreadsheet to make the name easier.

Regards

Hello
When the code stops and gives the error, if you select to debug - does it take you to the line : Set exWb = objExcel.Workbooks.Open("C:\Documents and Settings\msmith\My Documents\report1.xls") ?

I also have to create a reference to Excel in Word :
> go to developer menu
> Visual Basic (on left side)
> in the new window, go to Tools
> References
> Available reference list, select the Microsoft Excel object library

What version of word and excel you using ?

Regards

That is great, you could try to use that as a pattern for the other fields.

If you feel you are happy with this, please mark post as solved.

Regards

Hello
Perhaps you could post the full line of the error message - it may have some description after error 1004

It is usually not finding something, perhaps check that spreadsheet was not moved or anything renamed. And your word still has the reference to micorsoft excel object library
Perhaps also check that you don't have the spreadsheet opened at the same time that word is trying to open it - I am not sure if word will use existing open spreadsheet or the call will fail ?

Perhaps your suggestion of macros needing to be enabled, maybe it is getting stuck with the opening.
On Excel 2010, I can go to trusted centre and change the settings to open files with macros without disabling the macros - perhaps fiddle there

Regards