I have a number (7) of macros and would like to go to each one when the
previous one is finished running. I forgot the vba command to put at the end
of the macro to direct it to the next macro.

Thanks
Frank

Frank

Try Call Macro2 at the end of Macro1, or just Macro2 at the end of
Macro1.

Good luck.

Ken
Norfolk, Va


On Jan 30, 5:55 pm, Beep Beep <BeepB...@discussions.microsoft.com>
wrote:
> I have a number (7) of macros and would like to go to each one when the
> previous one is finished running. I forgot the vba command to put at the end
> of the macro to direct it to the next macro.
>
> Thanks
> Frank

I would be more inclined to add a main calling procedure instead of chaining
the macros together. That way they stay as stand alone parts able to run
individually... Try something like this...

Sub RunAll ()
call Macro1
Call Macro2
Call Macro3
end sub

Sub Macro1()
msgbox "Macro1"
end sub

Sub Macro2()
msgbox "Macro2"
end sub

Sub Macro3()
msgbox "Macro3"
end sub

--
HTH...

Jim Thomlinson


"Beep Beep" wrote:

> I have a number (7) of macros and would like to go to each one when the
> previous one is finished running. I forgot the vba command to put at the end
> of the macro to direct it to the next macro.
>
> Thanks
> Frank

sub macro1

blah

macro2
end sub

or put em together

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Beep Beep" <(E-Mail Removed)> wrote in message
news:E9A35F44-4130-4436-BE8D-(E-Mail Removed)...
>I have a number (7) of macros and would like to go to each one when the
> previous one is finished running. I forgot the vba command to put at the
> end
> of the macro to direct it to the next macro.
>
> Thanks
> Frank

Thanks Ken.

Here is what I added to the end of macro Sub AptOneInvoice()

Sub AptOneInvoice() going through AptSevenInvoice()

I tried adding your suggestion but must be doing something wrong

Here is what I added:

Call .AptTwoInvoice only to get the message
Invalid or unqualified message.

Thanks
Frank

Here is what my macros are called.


"Ken" wrote:

> Frank
>
> Try Call Macro2 at the end of Macro1, or just Macro2 at the end of
> Macro1.
>
> Good luck.
>
> Ken
> Norfolk, Va
>
>
> On Jan 30, 5:55 pm, Beep Beep <BeepB...@discussions.microsoft.com>
> wrote:
> > I have a number (7) of macros and would like to go to each one when the
> > previous one is finished running. I forgot the vba command to put at the end
> > of the macro to direct it to the next macro.
> >
> > Thanks
> > Frank
>
>
>

What's the . for?

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Beep Beep" <(E-Mail Removed)> wrote in message
news:6F3338B9-0328-459C-912C-(E-Mail Removed)...
> Thanks Ken.
>
> Here is what I added to the end of macro Sub AptOneInvoice()
>
> Sub AptOneInvoice() going through AptSevenInvoice()
>
> I tried adding your suggestion but must be doing something wrong
>
> Here is what I added:
>
> Call .AptTwoInvoice only to get the message
> Invalid or unqualified message.
>
> Thanks
> Frank
>
> Here is what my macros are called.
>
>
> "Ken" wrote:
>
>> Frank
>>
>> Try Call Macro2 at the end of Macro1, or just Macro2 at the end of
>> Macro1.
>>
>> Good luck.
>>
>> Ken
>> Norfolk, Va
>>
>>
>> On Jan 30, 5:55 pm, Beep Beep <BeepB...@discussions.microsoft.com>
>> wrote:
>> > I have a number (7) of macros and would like to go to each one when the
>> > previous one is finished running. I forgot the vba command to put at
>> > the end
>> > of the macro to direct it to the next macro.
>> >
>> > Thanks
>> > Frank
>>
>>
>>

Thanks Don

I took out the . and AptOneInvoice still runs fine, however it still does
not continue on to the next macro AptTwoInvoice

Thanks
Frank

"Don Guillett" wrote:

> What's the . for?
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Beep Beep" <(E-Mail Removed)> wrote in message
> news:6F3338B9-0328-459C-912C-(E-Mail Removed)...
> > Thanks Ken.
> >
> > Here is what I added to the end of macro Sub AptOneInvoice()
> >
> > Sub AptOneInvoice() going through AptSevenInvoice()
> >
> > I tried adding your suggestion but must be doing something wrong
> >
> > Here is what I added:
> >
> > Call .AptTwoInvoice only to get the message
> > Invalid or unqualified message.
> >
> > Thanks
> > Frank
> >
> > Here is what my macros are called.
> >
> >
> > "Ken" wrote:
> >
> >> Frank
> >>
> >> Try Call Macro2 at the end of Macro1, or just Macro2 at the end of
> >> Macro1.
> >>
> >> Good luck.
> >>
> >> Ken
> >> Norfolk, Va
> >>
> >>
> >> On Jan 30, 5:55 pm, Beep Beep <BeepB...@discussions.microsoft.com>
> >> wrote:
> >> > I have a number (7) of macros and would like to go to each one when the
> >> > previous one is finished running. I forgot the vba command to put at
> >> > the end
> >> > of the macro to direct it to the next macro.
> >> >
> >> > Thanks
> >> > Frank
> >>
> >>
> >>
>
>
>

Thanks Jim:

Here is what I got. The message I get is AptOneInvoice OK and so on for the
three of them. However it does not appear to run the actual individual
macros.

Thanks
Frank


' SubRun Macro
' Macro recorded 1/30/2007 by Frank

Sub RunAll()
Call AptOneInvoice
Call AptTwoInvoice
Call AptThreeInvoice
End Sub

Sub AptOneInvoice()
MsgBox "AptOneInvoice"
End Sub

Sub AptTwoInvoice()
MsgBox "AptTwoInvoice"
End Sub

Sub AptThreeInvoice()
MsgBox "AptThreeInvoice"
End Sub

"Jim Thomlinson" wrote:

> I would be more inclined to add a main calling procedure instead of chaining
> the macros together. That way they stay as stand alone parts able to run
> individually... Try something like this...
>
> Sub RunAll ()
> call Macro1
> Call Macro2
> Call Macro3
> end sub
>
> Sub Macro1()
> msgbox "Macro1"
> end sub
>
> Sub Macro2()
> msgbox "Macro2"
> end sub
>
> Sub Macro3()
> msgbox "Macro3"
> end sub
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Beep Beep" wrote:
>
> > I have a number (7) of macros and would like to go to each one when the
> > previous one is finished running. I forgot the vba command to put at the end
> > of the macro to direct it to the next macro.
> >
> > Thanks
> > Frank

Hi Frank,

I would suggest creating a new macro to call your macros vs. calling one
from another. None of the macros would work stand alone without error except
Macro7 which doesn't call another macro. I would call them using something
like this:

Sub RunMacros()
Call Macro1
Call Macro2
Call Macro3
Call Macro4
Call Macro5
Call Macro6
Call Macro7
End Sub


Alan


"The only dumb question is a question left unasked."


"Beep Beep" <(E-Mail Removed)> wrote in message
news:E9A35F44-4130-4436-BE8D-(E-Mail Removed)...
>I have a number (7) of macros and would like to go to each one when the
> previous one is finished running. I forgot the vba command to put at the
> end
> of the macro to direct it to the next macro.
>
> Thanks
> Frank

Hi,

It's a good start so far. I assume your actual macros are called
AptOneInvoice, etc. If this is the case, just delete the lines
Sub AptOneInvoice()
MsgBox "AptOneInvoice"
End Sub
Then run the macro RunAll again. If the real AptOneInvoice is now executed,
delete the other sub-routines below RunAll() as well.

But of course, if the macros are not called AptOneInvoice then you should
change the Call statements in RunAll accordingly.


--
Gerd


"Beep Beep" wrote:

> Thanks Jim:
>
> Here is what I got. The message I get is AptOneInvoice OK and so on for the
> three of them. However it does not appear to run the actual individual
> macros.
>
> Thanks
> Frank
>
>
> ' SubRun Macro
> ' Macro recorded 1/30/2007 by Frank
>
> Sub RunAll()
> Call AptOneInvoice
> Call AptTwoInvoice
> Call AptThreeInvoice
> End Sub
>
> Sub AptOneInvoice()
> MsgBox "AptOneInvoice"
> End Sub
>
> Sub AptTwoInvoice()
> MsgBox "AptTwoInvoice"
> End Sub
>
> Sub AptThreeInvoice()
> MsgBox "AptThreeInvoice"
> End Sub
>
> "Jim Thomlinson" wrote:
>
> > I would be more inclined to add a main calling procedure instead of chaining
> > the macros together. That way they stay as stand alone parts able to run
> > individually... Try something like this...
> >
> > Sub RunAll ()
> > call Macro1
> > Call Macro2
> > Call Macro3
> > end sub
> >
> > Sub Macro1()
> > msgbox "Macro1"
> > end sub
> >
> > Sub Macro2()
> > msgbox "Macro2"
> > end sub
> >
> > Sub Macro3()
> > msgbox "Macro3"
> > end sub
> >
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Beep Beep" wrote:
> >
> > > I have a number (7) of macros and would like to go to each one when the
> > > previous one is finished running. I forgot the vba command to put at the end
> > > of the macro to direct it to the next macro.
> > >
> > > Thanks
> > > Frank