I have this line of code which Transfers one record of a query and makes a Worksheet named A_EXPORT. This worked fine until I started having some linked references in the workbook to this newly created sheet A_EXPORT
Now instead of replacing the sheet every time I transfer data from Access to Excel it is adding a sheet named A_EXPORT1 etc
How can I get this to replace the sheet or can I copy the recordset to row 2 of A_EXPORT instead?
EXTREMELY IMPORTANT!!!!!!
DoCmd.TransferSpreadsheet acExport, 8, "A_EXPORT", str, True, ""
FollowHyperlink str
Now instead of replacing the sheet every time I transfer data from Access to Excel it is adding a sheet named A_EXPORT1 etc
How can I get this to replace the sheet or can I copy the recordset to row 2 of A_EXPORT instead?
EXTREMELY IMPORTANT!!!!!!
DoCmd.TransferSpreadsheet acExport, 8, "A_EXPORT", str, True, ""
FollowHyperlink str