[VBA] Macro starting time

[Anonymous]

Hi,

I added two macros to be run from a button in the ribbon.  The first time I run one of these macros after startup of Inventor, it takes a lot of time to run (approx. 5 sec.).  But the second and subsequent time the tools are ran, the process is pretty much instantaneous.  It's like the VBAeditor has to load on the background before the tool can process.

I arrived a this hypothesis because the VBAeditor is taking around 5-10 seconds to load for the first time but after the tool (macro) has ran once, the VBAeditor can be opened instantaneously.

I was wondering if this is a known issue and if there is a workaround.

Thanks

[jletcher · Accepted solution]

This one I can say YES it is know .

  Do you have it set to load macro on start up of Inventor?

 Even so the 1st time is slow....

[Anonymous]

That is what we call mutual help 🙂

[ekinsb]

This isn't an issue anymore with Inventor 2014.  Although the topic may not sound like it does, but this post attempts to explain the performance issues with VBA in previous releases.

http://modthemachine.typepad.com/my_weblog/2013/09/using-ms-access-databases-with-inventor-2014-vba....

[Anonymous]

Thanks, it was pretty informative.