Only first Call method is being executed when module is ran.

[Avocado87]

Hi,

I have module1 which when ran is supposed to:

1. Set variable "template"
2. Call 6 different Sub's with "template" as argument

The 6 subs all work perfectly when ran individually but when I try to use the Call method to run them only the first one gets ran, the other 5 never get executed. All 6 are Private Sub's and are in the same module. I have been looking all day for an answer and can't figure out why only the first one runs. If I comment out the first sub then only the second one runs, if I comment out the first and second only the 3rd runs and so forth, so this tells me they all work, but don't know what they aren't all being called. Any help would be greatly appreciated.

Example:

Sub module1()

tempFileName = Environ("Temp")& "\" & generate_guid()
Application.Workbooks.Open("PATH").SaveAs tempFileName
Set template = Application.Workbooks.Open(tempFileName)

Call miles(template)
Call names(template)
Call prequal(template)
Call cars(template)
Call trucks(template)
Call dates(template)

End Sub

Private Sub miles(ByRef template As Workbook)
...
code
...
End Sub

Private Sub names(ByRef template As Workbook)
...
code
...
End Sub

Private Sub prequal(ByRef template As Workbook)
...
code
...
End Sub
...
...
(and so on for the other 3 Private Sub's)


I think I included all information that I believe might be causing the issue. Any help with this would be greatly appreciated.

Thanks!

 

[Joe4]

Welcome to the Board!

Did you try adding in break points, and stepping through your code so you can see what happens?
I think it may be helpful to us to see all the code of your first module, to see if there is something in there that is "killing" it.

Also, did you really name your procedure "module1"?
I would not recommend that. Modules are containers that hold VBA code. So to name a VBA procedure "module1" is very confusing.
When you add modules, that is how Excel names them by default.
You basically should avoid naming your procedures, functions, and variables key words that are used for things like built-in Excel functions, properties, and methods.
I doubt that is the cause of your issues, but it would be good to totally eliminate that possibility by choosing a different name.