I have developed a macro which can be run two ways:

1. The usual way: Open an Excel application, open the workbook (call it
myWB) and run the macro (call it myMacro).
2. The automation way:
From a second workbook (call it MasterWB), create a new Excel application
via automation, open the workbook (myWB) in the new application and run the
macro (myMacro).

Here's the issue that I'm having - the macro runs faster when run the "usual
way" than the "automation way". I don't get it.

Anybody have an idea why this happens?

Thank you,
Mark




I open an Excel Application and workbook via automation.

So there are two Excel Applications open at the same time. The first Excel
Application opens the second Excel Application and a workbook.

A macro in the workbook of the second Excel Application is run.

What I notice is the following:
The macro runs slower when run via the automation