Script to switch/activate from Word to Excel in Office 2016 RRS feed

  • Question

  • To accomplish switching to Excel in Office 2007 one could simply use VBA script: Tasks("Microsoft Excel").Activate.

    However, now using Office 2016 and the same script won't work. I've tried AppActivate "Microsoft Excel" - no luck there either. Not sure if Permissions is interfering with this latter instruction.

    Anyone know a comparable script to achieve this in Office 2016?

    • Edited by Ricardo1-1 Thursday, October 20, 2016 5:08 AM
    • Moved by Bill_Stewart Thursday, October 20, 2016 2:01 PM Move to more appropriate forum
    Thursday, October 20, 2016 5:08 AM

All replies