Call one macro from another

[Legacy 96851]

I have a macro called Extract that opens all the files in a directory (and does other stuff with them). My second macro (named Divide) needs to be run on each of these files before Extract can be run. Is there a way I can make Extract call Divide on each file after it opens it?

Thanks.

 

[RoryA]

Yes, you can call Divide from Extract. Just add either:

Divide

or

Call Divide

to your Extract code in the relevant location (assuming both macros are in the same workbook)

 

[Richard Schollar]

Yes.

Call your Divide macro from your Extract macro after each file is opened in Extract. Whether this will work does depend on how each is coded, but you have yet to provide your existing code, so it is difficult to comment on this point.

'to call one macro from another:
 
Sub Message()
MsgBox "Hello"
End Sub
 
Sub Test()
Message
End Sub

In the above, if you run Test, it calls Message.

 

[Legacy 96851]

I didn't post my source code because it is rather long and didn't seem relevant. If it would help, I will, but the code is pages long, so that seems ridiculous.

When I put this in my code

Set sourcewb = Workbooks.Open(myPath & sumfile)
Call Divide

I get an error saying "Compile error: Expected variable or procedure, not module"

 

[RoryA]

Did you name your module Divide?

 

[Richard Schollar]

Do you also have any variables named Divide as well as a subprocedure? This can confuse VBA (in which case you should name your variables to something else).

 

[Legacy 96851]

Did you name your module Divide?

Thanks much, you got it!