PDA

Click to See Complete Forum and Search --> : Speed of VB vs Excel macros.


Al Smith
Jan 11th, 2000, 12:24 AM
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.

netSurfer
Jan 11th, 2000, 12:29 AM
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.