Cheers knew the alerts command in access but not excel, thanks for that.
Figured it out now, realising that i didnt have to do a acExport from access, all i had to do was open a recordset and also open the excel object(link) and then reference the cells to fields in the recordset, which worked...
Hi,
I have recently been doing a lot of work on this area. Im able to export to where i want to and run macros through the VBA code inside of Access to edit the spreadsheets. This is ok if your making a new excel workbook/worksheet.
But what im stuck on is exporting to a so called template in...