VBA to switch back to Excel

[Gil149]

I wrote some VB code (with help) to gather information from SAP through Excel. Problem is when I run it, the SAP screen appears over the Excel screen...I would like to switch back to the excel screen. I tried just reactivating the workbook...no go though. Any ideas?

 

[Gary McMaster]

Try

'Capture Application.Caption in string variable before switch
AppActivate Application.Caption

or

AppActivate "Text Showing in Excel Tiltle Bar"

Gary

 

[Gil149]

Dang, your code works...the problem is that I guess I need Excel to be forced to be the top most window until the code is finished running...

 

[Gary McMaster]

You could try "DoEvents" before and/or after AppActivate.

I suspect it will probably be more complicated than that but it's easy enough to try.

DoEvents
AppActivate ...
DoEvents

Gary