Macro Size Limit / open macros with macros?

  • Thread starter Thread starter andycharger
  • Start date Start date
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?
 
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
 
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,
 
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
 
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
 
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
 
Back
Top