View Single Post
 
Old 02-26-2015, 04:06 PM
Macer Macer is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2015
Posts: 9
Macer is on a distinguished road
Default 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.
Reply With Quote