I have written a code that will change the excel wordbook and saveas under a document name. I use task scheduler to open the excel sheet daily in order to get and save a daily production summary.
Is there a way to disable or delete the macro automatically after the macro has ran?
The following is the visual basic code
Can I put some type of code before "Application.Quit" to erase this code so the daily summaries that are emailed won't have the macro in it?Please Login or Register to view this content.
Bookmarks