Running 64-bit Excel 2013 on Windows 8.1 Pro

Executing the Application.ActivateMicrosoftApp method with an invalid numeric argument raises run-time error 1004: Method 'Application.ActivateMicrosoftApp' of object '_Application' failed

but...

Executing the Application.ActivateMicrosoftApp method with an uninitialized variant variable launches Calculator (calc.exe)

Sub Test()
    Dim a As Variant
    Application.ActivateMicrosoftApp a
End Sub

Can anyone reproduce this behavior?

Hi,

We don't provide suggestions about coding in this current forum, since this question is about development, I suggest you post the question in the Excel for Developers forum:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards,

Melon Chen
TechNet Community Su