Thread
:
Calling another macro?
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Calling another macro?
If you have imported a module then it is part of the current workbook and is
callable. If you are running code to import using VBE extensibility then
probably not.
--
Regards,
Nigel
"Charlotte E." wrote in message
...
Hmmmm.....
I use 'Application.Run' because it is apparrently the only way to run
macros in imported modules!
Or is it?
Is there any way to run macros in imported modules with 'Call'?
Thanks,
"Bob Phillips" skrev i en meddelelse
...
Application.Run would normally be used to call procedures with variables,
that is store the macro name in a variable as you process, or in another
workbook.
If the macro is in the same workbook, Call is far more efficient.
You could even use Call if the macro is in another workbook, if you set a
reference (ToolsReferences) to the other workbook in the calling
workbook.
--
__________________________________
HTH
Bob
"Charlotte E." wrote in message
...
Hi,
what's the diffrence between these two ways of calling another macro
from within a macro?
Call OtherMacro
Application.Run "OtherMacro"
Thanks,
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]