| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save copy of workbook
I need to save a duplicate copy of a workbook each time it is saved,
overwritting the duplicate. I tried this code and it did not work. No errors but it did not create the copy. Private Sub Worksheet_beforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ActiveWorkbook.SaveCopyAs "g:\EHSAdr.xls" End Sub Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save a copy of personal workbook? | Excel Discussion (Misc queries) | |||
| Trying to use VBA to save a copy of a workbook | Excel Discussion (Misc queries) | |||
| Use a Macro to Save a Copy of a Workbook? | Excel Programming | |||
| Save a copy of a Workbook without its modules | Excel Programming | |||
| copy 3 sheets & save them into new workbook | Excel Programming | |||
Threaded Mode
