I am working on a reporting macro and the final piece copies a lot of data into a template spreadsheet. This spreadsheet must be in the same directory as the sheet with the macro code in it. To make sure they don't get separated I have embedded a copy of the template into the macro.

I can manually access the template by doubling clicking on the embedded icon and saving the file but I can't seem to figure out how to do this from code. Recording doesn't work.

Does any one know.

Any help would be great.

Thanks in advance ;o)

Not sure what you mean by this, but if you mean you physical put a copy in the macro, it won't work.


Perhaps you could include code to the path for the template. Such as

Workbooks.Open Filename:= _
"C:\Documents and Settings\user01\My Documents\myTemplate.xlt"