Calling a macro from within a Macro, or writing a subroutine

[Brat]

It seems like it should be easy, but the debugger keeps telling me I am wrong. Soo...

I have written a macro, let's call it "BeenThere".

While running the BeenThere macro want to run the macro DoneThat and then continue the BeenThere macro.

I attempted to figure this out with MSHelp, it tells me that I can't call a subroutine from a subroutine. Are macros subroutines?

Is there a way to pull this off?

 

[kskinne]

Re: Calling a macro from within a Macro, or writing a subrou

you can call a macro from within another macro...perhaps you could post a sample of your code, and also post which line specifically it is getting caught on

kevin

 

[DaK888]

Re: Calling a macro from within a Macro, or writing a subrou

private sub beenthere()

(blah blah blah beenthere code)

donethat 'macro we want to run in beenthere

(blah blah blah more code for been there)

end sub

Its that easy, just place the name of the procedure where you want it to run.

DaK

 

[LTunnicliffe]

Re: Calling a macro from within a Macro, or writing a subrou

Yes... A couple of things to check:

1. Are you passing any variables between the macros? If so you need to type "Call DoneThat(WhatEverVar)."

2. Make sure you Sub is not Private DoneThat. If so change it to Public DoneThat.

Hope this helps!

 

[Brat]

Re: Calling a macro from within a Macro, or writing a subrou

Thanks folks. I got it to run.

Gayle