Hi,

I want to get data from another application (SAP). I'm using VBA i
Excel to control SAP using the command SendKeys. My goal is to launc
SAP, log in, perform some actions and save the results in a dat.file.
have already completed the code for doing so and it works just fine.

However, my problem is that if, while running the macro, anothe
application (for example my ergonomic program, the company messenge
service or the screensaver) pops up, the macro sends the keys to th
wrong application.

Is there any way I can prevent such a situation? Or when it's no
possible to prevent, at least detect that it's gone wrong? Or is i
possible to activate the SAP window before every time Excel sends keys
Or does anyone have a better solution?

TIA,

Anne

--
Message posted from http://www.ExcelForum.com