Macro Size Limit / open macros with macros?

A

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?
 
N

Nikos Yannacopoulos

Andy,

Definitely possible!
Call OtherMacroName(parameters)

HTH,
Nikos
 
A

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
 
B

Beto

andycharger said:
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?
Click to expand...

Yes, the execution is in series not in parallel.

Regards,
 
A

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
 
N

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
 
A

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
 
Top