Pause macro, select file, continue macro

It is possible

Withou seeing your macro code I can not advice the best way to do it

1 option is have a 3rd macro that calls the other 2

Sub MyMainMacro()
    Call Macro1
    Call Macro2
End Sub

Another option is to have macro1 call macro2 by placing a call command before the End Sub

A 3rd option is to combine the 2 macros codes into 1 macro