D
DoctorV
I have this line of code which Transfers one record of a query and make
a Worksheet named A_EXPORT. This worked fine until I started havin
some linked references in the workbook to this newly created shee
A_EXPORT
Now instead of replacing the sheet every time I transfer data fro
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 t
row 2 of A_EXPORT instead?
EXTREMELY IMPORTANT!!!!!!
DoCmd.TransferSpreadsheet acExport, 8, "A_EXPORT", str, True, ""
FollowHyperlink st
a Worksheet named A_EXPORT. This worked fine until I started havin
some linked references in the workbook to this newly created shee
A_EXPORT
Now instead of replacing the sheet every time I transfer data fro
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 t
row 2 of A_EXPORT instead?
EXTREMELY IMPORTANT!!!!!!
DoCmd.TransferSpreadsheet acExport, 8, "A_EXPORT", str, True, ""
FollowHyperlink st