Cellardoor
Member
Dear all good morning
(Probably ther'es allready an answer for this question, but i could't find it)
So, i have a macro that runs another macros
Sub Report()
Call Macro 1
Call Macro 2
Etc...
End sub
But these macros need to have a specific file allready opened
So, i would need that this "Sub Report()" could do something like:
Sub Report ()
Dim Path as String
Path = Sheet ("File 1"). Range ("D4").Value
IF this Path is allready open, then Call those macros (Macro 1, Macro 2, Etc).
IF not open, than open this path and then Call the macros.
Many thanks
Regards
(Probably ther'es allready an answer for this question, but i could't find it)
So, i have a macro that runs another macros
Sub Report()
Call Macro 1
Call Macro 2
Etc...
End sub
But these macros need to have a specific file allready opened
So, i would need that this "Sub Report()" could do something like:
Sub Report ()
Dim Path as String
Path = Sheet ("File 1"). Range ("D4").Value
IF this Path is allready open, then Call those macros (Macro 1, Macro 2, Etc).
IF not open, than open this path and then Call the macros.
Many thanks
Regards