View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Beep Beep Beep Beep is offline
external usenet poster
 
Posts: 101
Default Continuous Macros

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

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