Hi,
It seems that when I call an Excel macro from VB it runs many time faster than if I create the macro in VB itself.
Is this just my imagination?
Thanks,
Al.
Printable View
Hi,
It seems that when I call an Excel macro from VB it runs many time faster than if I create the macro in VB itself.
Is this just my imagination?
Thanks,
Al.
it depends on what the macro does. Keep in mind that chances are, when writing it in VB, it has to open up Excel, that's probably a good portion of the time difference.