Run Macro on Save As

I have several macros that I have downloaded and assigned to hot keys. However, I have one (create file path) that I would like to run when i initiate the 'Save As' command. Is that something that is relatively easy to do? I am pretty unfamiliar with macros/coding in general, but I am willing to learn.

Thank you!

  • I don't believe it would be possible in the way you're thinking (automatic). You could, however, make your own special macro to simply save as and include the create file path code. Drop the icon for that macro onto your workspace.

    • Would I be able to do that using the macro recorder? Or would I need to add it into another macro manually?

      • Start from the macro manager docker. Alt+Shift+F11

        right-click Visual Basic for Applications. Choose "New Macro Project"

        Name it as you like. Just remember no spaces so It's better to Use Caps i.e. "CustomSaveAs" without quotes, hit save

        You'll see it pop up and highlighted at the bottom, click off of it then right click on it and Choose "New Module"

        Again click off then right click on Module 1 and choose New Macro

        In editor copy all the code from your "creatfilepath" macro and paste into this new one.

        add the following as the last line

        SendKeys "^+(s)"