Create an additional worksheet unintentionally at exporting (1 Viewer)

FuzMic said:

DB guy your €£$ worthed of placing a range at the end did not work. It is not range but a table in the database

I think range is mainly for import.

Click to expand...

FuzMic said:

Hi guys

i use following to export a table eg Tb01 to a Excel eg X01.xls

docmd.transferSpreadsheet acExport, 8, Tb01, X01, true

by doing so either
1. if there is no worksheet by the name of Tb01, it will create one & export content to it
2 if there is the folder Tb01 it will just replace it's contents

above is what i need

however if the x01.xls is change or whatever it create another worksheet Tb011 & not replace the old contents in Tb01 or create a new Tb01

Any advice to understand & satisfy my need

Click to expand...

FuzMic said:

You may have to identity path of x01.xls in the code

Ii is reproducible in all instances

Click to expand...

Sub TestXLSExport()
DoCmd.TransferSpreadsheet acExport, 8, "Transactions", "C:\Temp\SSAFA Test Transactions.xls", True
End Sub

FuzMic said:

Not shared but it should not matter
I will prefer to have name of xls simple without space
So you have a table named transactions in your current project

Click to expand...