View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jef Gorbach Jef Gorbach is offline
external usenet poster
 
Posts: 59
Default Running one macro from another

sounds like macro1 processes Master to create file2 which macro2 then
processes to create file3 -- thus the two macros CANT run at the same time,
right?
if so, simply put the Call Macro2 command at the end of the first macro.


"Dave Peterson" wrote in message
...
Not to me.

You can put them in different modules (if the subroutines get very

large)--or if
it makes more sense from a organization aspect.



Megadrone wrote:

it's running them both at the same time. I have these Sub's in the same
module is that a problem?

"Dave Peterson" wrote:

Maybe...

Option Explicit
Sub RunBoth()
call FirstMacro
Call SecondMacro
end sub



Megadrone wrote:

I have a macro that takes info from a Master spreadsheet & generates

a
separate spreadsheet. I have another macro that takes that generated
spreadsheet & generates another spreadsheet. My question is: How can

I run
these as two macros as one single Macro?

--

Dave Peterson


--

Dave Peterson