Macro Size Limit / open macros with macros?
 

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?


---
Message posted from http://www.ExcelForum.com/

Macro Size Limit / open macros with macros?
 

Andy,

Definitely possible!
Call OtherMacroName(parameters)

HTH,
Nikos

"andycharger " wrote in message
...
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?


---
Message posted from http://www.ExcelForum.com/

Macro Size Limit / open macros with macros?
 

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

--
Message posted from http://www.ExcelForum.com

Macro Size Limit / open macros with macros?
 

andycharger < wrote:

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Macro Size Limit / open macros with macros?
 

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

--
Message posted from http://www.ExcelForum.com

Macro Size Limit / open macros with macros?
 

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 " wrote in message
...
When I type my code to call other macros, it says sub or function not
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]


---
Message posted from http://www.ExcelForum.com/

Macro Size Limit / open macros with macros?
 

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

--
Message posted from http://www.ExcelForum.com