| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing xlBook.SaveAs in Access code to overwrite existing workbook?
I'm making my first forays into Access with code. As part of a data
export sub, I create an instance of Excel and add a new workbook. I create the name of the workbook with the date in it. As I'm testing this, Excel keeps giving me a warning that a workbook already exists. (All this is in Excel and Access 2003, by the way.) How can I write the code in Access to allow Excel to overwrite the previous file in the SaveAs? Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| xlBook.SaveAs (documentName) when file open by another process | Excel Programming | |||
| Unshared workbook allowing write access to more than 1 user | Excel Discussion (Misc queries) | |||
| Shared workbook only allowing read-only access | Excel Discussion (Misc queries) | |||
| SaveAs and always overwrite? | Excel Programming | |||
| Using SaveAs Statement to overwrite existing File | Excel Programming | |||
Threaded Mode
