Excel Spreadsheet SaveAs

[mharroff]

I have a need to use Access to open a spreadsheet and then make 1 small change to the spreadsheet and save it as another file name.

The filename that I save to is ALWAYS the same. However, everytime I save it I am prompted whether to overwrite the existing file. As this is ALWAYS a yes answer I would like to know if there is a way to not be prompted.

I am using the following to close my spreadsheet.

objExcel.ActiveWorkbook.Close True, "Filename"

 

[CPUburn]

hi,

might be a bit tricky when something goes wrong, but you can just try to kill the existing file:

kill "filename"

CPU-burn

 

[JoeMiller]

Along those same lines:

1) Rename the existing file for backup purposes
2) Write the new file using your procedure
3) Kill the backup (if necessary)

HTH Joe Miller
joe.miller@flotech.net