nagovind Member Oct 30, 2010 #1 Dear All !! Is it Possible to Run a macro after saving a excel file using save as function with new file name ? In otherwords "code" should run automatically AFTER 100% completion of save operation using save as function Please help
Dear All !! Is it Possible to Run a macro after saving a excel file using save as function with new file name ? In otherwords "code" should run automatically AFTER 100% completion of save operation using save as function Please help
Hui Excel Ninja Staff member Oct 30, 2010 #2 Nagovind Excel has two events in VBA which revolve around Saving The names tell which is which Sub Workbook_AfterSave(ByVal Success As Boolean) & Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ByVal in the AfterSave event allows for you to check that the save was successful and adjust your code if it wasn't
Nagovind Excel has two events in VBA which revolve around Saving The names tell which is which Sub Workbook_AfterSave(ByVal Success As Boolean) & Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ByVal in the AfterSave event allows for you to check that the save was successful and adjust your code if it wasn't
nagovind Member Oct 30, 2010 #3 Hui Thanks very much sometimes some usual things are not clicking thanks for your timely response; absence on mind great !!
Hui Thanks very much sometimes some usual things are not clicking thanks for your timely response; absence on mind great !!
nagovind Member Oct 30, 2010 #4 Hui Thanks very much sometimes some usual things are not clicking ; for me absence on mind thanks for your timely response u r great !!
Hui Thanks very much sometimes some usual things are not clicking ; for me absence on mind thanks for your timely response u r great !!