AppActivate problem when called twice

S

SuperJas

Hi

I've been working on controlling a Non-Microsoft application from Excel VBA using the AppActivate and SendKeys procedures

Currently, the Appactivate command resides inside a For-Next loop (and I think it needs to since I'll be switching to Powerpoint within each run of the loop)

I've been finding that, after the 1st run through, it does not automatically re-activate this external application until I manually switch back to Excel by clicking on it..

My question is: Would there be a way in code to either Switch back to Excel (similar to what happens when there's an error in the program) or Deactivate the external application, such that when the program hits another AppActivate command, it'll zoom directly back to external application, like it did on its 1st run through

I am using Excel 2000

Thanks heaps for your suggestions

SuperJas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sendkeys to external application not working 3
Application Name differences between Excel 2003 and 2007 4
AppActivate problem 3
Why doesn't this work on other computers? 2
Reliably activate PowerPoint, do something, Activate Excel 1
AppActivate 1
AppActivate problems or is there a better way to take focus froma non modal user form 1
AppActivate with Current Database name 1

Top