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.