Run Multiple Macros Throws Error

[tomgrandy]

Trying to run multiple Macros at once so I can assign one button that will run three Macros sequentially.

This is what I have from searching these forums:

Sub Keywords()
    Call KeywordFlakedArtifacts_A_K
    Call KeywordFlakedArtifacts_K_Z
    Call KeywordNonFlakedArtifacts
End Sub

But it throws the following error with the Sub Keywords() highlighted when I debug:

 

[Trevor G]

Try changing the module name so there isn't a clash. A naming suggestion for module sheets is mod or bas before the assigned name so in your case:
modKeyWords as the module sheet name and then try your routine to call the other procedures.

 

[tomgrandy]

Changed Module Name but still getting the error of "Expected Variable or Procedure Not Module":

Sub modKeyWords()
    Call KeywordFlakedArtifacts_A_K
    Call KeywordFlakedArtifacts_K_Z
    Call KeywordNonFlakedArtifacts
End Sub

 

[Trevor G]

You've changed the procedure name not the module sheet names. In the project window on the top left change each module sheet name as I suspect your using the same name as each procedure name:
Change

KeyWordFlakedArtifacts_A_K
to
modKeyWordFlakedArtifacts_A_K

And change the other module names not the procedures. Then your call procedure should run ok. Change the procedure back to KeyWords

 

[tomgrandy]

Thanks for your response @Trevor G ! Here is a snippet of my Project Window. The Sheet Name, I believe, is not the same as the Modules or am I looking at the wrong box?

 

[Trevor G]

In your screen capture (picture) you can see the folder named Modules. This folder holds each of your programming sheets called modules. This is where you should name each one with mod at the beginning, like this:

modKeywordFlakedArtifacts_A_K
modKeywordFlakedArtifacts_k_Z
modKeywordNonFlakedArtifacts

Next
On each module sheet this is where I think each procedure is named as follows:
KeywordFlakedArtifacts_A_K
KeywordFlakedArtifacts_k_Z
KeywordNonFlakedArtifacts

Therefore there should be no clashing with the procedure names (you might call them macros). Therefore your call procedure should work as long as the title doesn't clash with any other name you have used.

Your first thread #1 would be correct


Sub Keywords()
Call KeywordFlakedArtifacts_A_K
Call KeywordFlakedArtifacts_K_Z
Call KeywordNonFlakedArtifacts
End Sub

 

[tomgrandy]

Did some more searching @Trevor G and discovered that I needed to repeat the Call in order for it to recognize that I was calling a Module (I think).

Anyway, this is what worked:

Sub RunALLKeyWordQueries()
    KeywordFlakedArtifacts_A_K.KeywordFlakedArtifacts_A_K
    KeywordFlakedArtifacts_K_Z.KeywordFlakedArtifacts_K_Z
    KeywordNonFlakedArtifacts.KeywordNonFlakedArtifacts
End Sub

••••ˇˇˇˇ

 

[Trevor G]

As long as you've found a working solution and it works then great news.

Thank you for letting me know

 

[tomgrandy]

@Trevor G - Thank you for taking the time and helping a newb understand a bit more about VBA Scripts. Much appreciated!