Can DocumentBeforeSave replace FileSaveAs
This is probably a long shot but I was wondering if there was a way that I could use Documentbeforesave() to work like FileSaveAs() and FileSave() events. My code for those events did work until we transferred to Office 2013. I was using FileSaveAs and FileSave to save a file then run the my code afterward. My code needs to be afterward because it tracks file locations and logs it in another file. Since DocumentBeforeSave runs on any type of save, I was thinking I need logic kind of like the following. Sub DocumentBeforeSave()| If SaveAs was selected| Run SaveAs| Run my Macro| Prevent SaveAs from running| again. Exit Sub | else If Save was selected | Run Save | Run my Macro | Prevent Save from running again. | Exit else End Sub | Is it possible to do this or am I just trying to create the impossible.
Last edited by Macer; 02-27-2015 at 02:56 PM.
|