Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sub BUandSave2()
how can i adapt the following macro to run when you exit
the workbook instead of when i save. Sub BUandSave2() Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs Filename:="T:\Invoices\Batch Book" & _ ActiveWorkbook.Name ActiveWorkbook.Save Application.DisplayAlerts = True End Sub thanks mark |
#2
|
|||
|
|||
hi,
Put the code in the on close event of the thisWorkbook module. -----Original Message----- how can i adapt the following macro to run when you exit the workbook instead of when i save. Sub BUandSave2() Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs Filename:="T:\Invoices\Batch Book" & _ ActiveWorkbook.Name ActiveWorkbook.Save Application.DisplayAlerts = True End Sub thanks mark . |
#3
|
|||
|
|||
cheers
-----Original Message----- hi, Put the code in the on close event of the thisWorkbook module. -----Original Message----- how can i adapt the following macro to run when you exit the workbook instead of when i save. Sub BUandSave2() Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs Filename:="T:\Invoices\Batch Book" & _ ActiveWorkbook.Name ActiveWorkbook.Save Application.DisplayAlerts = True End Sub thanks mark . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|