I am trying to export data from a recordset to an Excel template. This Excel file has macros that assist my users in managing the data they receive.
I have no problem doing a straight TransferSpreadsheet to a new Excel file, but I have been unsuccessful in getting the data to the existing template, then saving as a new file so the template can be used throughout the recordset.
I don't really have any code to share at the moment, I just need some advice or guidance.
I have no problem doing a straight TransferSpreadsheet to a new Excel file, but I have been unsuccessful in getting the data to the existing template, then saving as a new file so the template can be used throughout the recordset.
I don't really have any code to share at the moment, I just need some advice or guidance.