Hi,
I'm wanting to export data from Access in to an Excel template. I'm using a query and command button to do this, and so far have been able to export to Excel ok, however I want to send this to a template where the top 2 rows have nicely formatted heading. So essentially, I want to export data to row 3 of the excel template.
The methods I've used so far seem to overwrite the template rather than leaving the template as is and saving the output a new file. Therefore, if this is also possible, I want the export to use the template file, but ensure that a new file is saved leaving the template blank to be used again and again.
I seem to be getting lost in a world of VBA code, so any held will be greatly appreciated.
Thanks,
Phil