VBA code for switching view back to Excel from Acrobat after PDF creation

[jardenp]

As part of my macro, I save the worksheet as a PDF and have it leave the resulting Acrobat window open for future use by the user. However, I need it to switch the viewed window back to Excel because I do other things to the Excel workbook and want those results to be visible. I know how to get the code to switch back to acting on the Excel workbook, so this is an issue of which window is visible on the screen. Any suggestions?

Thanks!

JP in IN

 

[Trevor G]

Look to use SEND KEYS this should handle switching windows.

 

[jardenp]

Sorry for the late reply. Thanks for the suggestion. I'm hesitant to do that because it can't specifically call up the excel window and I'd hate to have it go awry and try to execute code on the wrong thing. However, I have no other alternative, so I may give it a go.

Thanks again!

 

[GooberTron]

A Windows API call via VBA should be able to handle this. I've not a lot of experience in this area but this link has some tips;
10+ of my favorite Windows API functions to use in Office applications - TechRepublic