I'm using the following sub:
Please Login or Register  to view this content.
On some files: it opens the file but ends the macro immediately, leaving AutomationSecurity set to msoAutomationSecurityForceDisable.

But not all files.
Some files it opens fine.

Is there some way to determine what it is about a file that is causing the macro to end?