Word 2016 Save As Command Trigger VBA

Question

In previous versions of Office, When Clicking File>Save As, Word would invoke the FileSaveAs() command. I have a macro that is a sub command of this that prompts for additional document information. With this Macro is 2016 Clicking File>Save As seems to no longer invoke that command. 

Anyone know what command is invoked now? or any way to to get a macro to trigger when users click File>Save as in Word 2016?

Sub FileSaveAs()

     On Error Resume Next

     Dialogs(wdDialogFileSummar

Answer 1

Hi Mike,

For reasons known only to the wizards who built VBA at Microsoft, Word uses the special name AutoOpen, but Excel requires an underscore in Auto_Open. (More info here.)

Also, Excel doesn't have a direct equivalent to Word's AutoNew (which runs when you start a new document based on a template that contains that macro). You may as well delete the AutoNew macro from the Excel sheet and just leave it in Word. If you need that functionality in Excel, see this thread.

Answer 2

Would this also be possible using Excel and utilizing the Personal.xlsb workbook? I have been trying to perform the equivalent with the xlDialogSummaryInfo prompt but am unable to get it to trigger.