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 |
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 . |
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 . . |
All times are GMT +1. The time now is 12:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com