easiest way to get window focus with sendkeys?

**qwyz** · 05-27-2009, 09:00 AM

Hi, Im trying to make a macro that pastes data into notepad repeatedly, the problem Im having though is switching focus from excel to notepad, then back to excel. I try using AppActivate myAPP (myAPP being notepad) but no matter how I write it, whether I use brackets or quotes or whatever, it always returns an error, unless AppActivate comes immediately after it opens notepad. Im starting to think that AppActivate doesnt truely do anything. Im not very familiar with API or more complex VB, so Im looking for something easy, even if its not stable.
Thanks...

**Andy Pope** · 05-27-2009, 09:06 AM

Can you not just write the required information to a file, do you have to have notepad open at all?

**qwyz** · 05-27-2009, 09:21 AM

Oh I see what youre saying. it would be nice, but no, I dont need it open.

**Andy Pope** · 05-27-2009, 09:38 AM

you can use VBA code to create/append to an text file.

commands such as Open, Print and Close would be used.
There are examples on the forum, maybe search for I/O

If not post back with details of what you currently do manually and include example files.