• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Enable a macro AFTER completly saving a file using save as function

nagovind

nagovind

Member
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
 
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
 
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 ; for me absence on mind

thanks for your timely response

u r great !!
 
You must log in or register to reply here.
Back
Top