Here is a better explaination of the challenge I need help with. How do I get past the MsgBox "This is Book2" in an automated way? In Workbook1:
Sub B1M1()
Application.Run "'" & "Book2.xls'!B2M1"
MsgBox "This is Book1, returned from Bk2"
End Sub In Workbook2:
Sub B2M1()
MsgBox "This is Book2"
End Sub From earlier post (FYI): Just guessing but am looking at the RUN Method documentation (F1 in VB editor) and it shows how you can pass two variables, should I pass a SendKey to answer the MsgBox? Last last night I reported that processing was not passing back to the host workbook but I just tested this again and it is passing back.
|