VBA help: Workbook A calls macro on workbook B that closes Workbook A and continues

[ks11]

Hello guys,

I have this problem exemplified in the picture bellow.

The problem is: when I close workbook A, the macro sub B stops running.

I tried this codes:

Sub A()
    Workbooks("WorkbookB.xlsm").Close
    (Call other subs)
End Sub

Sub B()    
    [B]Workbooks("[COLOR=#574123]WorkbookA[/COLOR].xlsm").Close*[/B]
    (Call other subs)
    Application.Run "WorkbookA.xlsm!A"
End Sub

* last line executed

Can anyone help me, please?

Thanks in advance.

 

[JLGWhiz]

Since Sub A is the Parent Sub in Workbook A, when workbook A closes, it effectively invokes an Exit Sub on Sub B in Workbook B. I believe you would have better luck if you put your Sub procedures in an XLA file and ran them like an Add In.