ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   .saveas and .close methods from Access (https://www.excelbanter.com/excel-programming/287097-saveas-close-methods-access.html)

Marius from Rome

.saveas and .close methods from Access
 
My Access application opens an existing Excel worksheet and inserts data in
it.
My application should give my worksheet a new file name (i.e.
newworksheet.xls), save and close it.
I attempted using the .saveas and .close methods, but if a file with the
same name altrady exists I don't get any error while the user is prompted to
save changes in the original file.
Can anybody please suggest the best and simplest way to check if a file with
the new name already exists and/or to overwrite it?
Regards
marius




All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com