Macro Size Limit / open macros with macros?

[andycharger]

I need to know something....
Can you open another macro from a macro? Reason I ask is that I have a
macro that has exceeded the file size limit and need to open 2 macros,
one after the other. Is this possible?

 

[Nikos Yannacopoulos]

Andy,

Definitely possible!
Call OtherMacroName(parameters)

HTH,
Nikos

 

[andycharger]

Nikos,

If I call 3 macros, say macro1, macro2 and macro3, will it finishin
running the entire length of Macro1 BEFORE moving on to running macro2

 

[Beto]

Nikos,

If I call 3 macros, say macro1, macro2 and macro3, will it finishing
running the entire length of Macro1 BEFORE moving on to running macro2?

Yes, the execution is in series not in parallel.

Regards,

 

[andycharger]

When I type my code to call other macros, it says sub or function no
defined.

How do I get around this?

Here is my code
[vb]
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 10/02/2004 by adavies
'

'
Call Macro1
Call Macro2

end sub
[/vb

 

[Nick Cranham]

Andy,
Well, follow the advice and define Macro1 and Macro2, or whatever you want
to call your subs/functions.
I guess you recorded Macro1 and Macro2 previously, then deleted them.
Or recorded them into a different workbook.

NickHK

 

[andycharger]

Nick,
What do you mean by "define"?
Do you mean declare?
If so, how do I do this?

Do you mean like....

Dim Macro1 as New Macro

or some thing like that