Run Module1 first then automatically run Module2
 

This is probably simple but I have two modules that I had to break up
because it was too large. Anyway, I cannot figure out what object or
syntax or whatever to use to go to Module2 when it is done with Module
one. Could someone point me in the right direction.

Thanks in advance,

Bowbender

Run Module1 first then automatically run Module2
 

Not modules but macros.

Call the macros in Module 2 from the last macro in module 1.

--
HTH

Bob Phillips

wrote in message
ups.com...
This is probably simple but I have two modules that I had to break up
because it was too large. Anyway, I cannot figure out what object or
syntax or whatever to use to go to Module2 when it is done with Module
one. Could someone point me in the right direction.

Thanks in advance,

Bowbender

Run Module1 first then automatically run Module2
 

Sorry bout that, I am in no way any sort of expert. How would you call
it exactly, I am really lost here.

Thanks

Run Module1 first then automatically run Module2
 

Sub RunAllMacros()
Call Macro1 '(or whatever the first macro name is)
Call Macro2 '(or whatever the second macro is)
end sub

ps - Macros are stored in modules, you cannot call a module... only a macro

hope this helps


" wrote:

Sorry bout that, I am in no way any sort of expert. How would you call
it exactly, I am really lost here.

Thanks

Run Module1 first then automatically run Module2
 

Sorry, found it. It seems if you place the name of the macro inside
the other, it will run it. Man do I feel dumb.

Thanks again.