TransferSpreadsheet from Access to Excel creates Resume file 1

[sophie]

When I transfer the spreadsheet from Access to Excel, it automatically asks me " A file named Resume.xlw already exists. Do you want to replace it ?"
I don't want it to create that file Resume...How can I desactivate this ?
Thank you in advance
Sophie

 

[MichaelRed]

Look up TransferSpreadsheet in Access Help. The spreadsheet name is the fourth argument. You need to change this to specify whatever folder/filename you want to create.
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over