Yes, SendKeys should be a last resort. But last resorts are used as
last resort so here we go.

You will get VBA help on SendKeys parameters, which I won't repeat
here.

As you mentioned, sent keys operate on the window that currently has
the focus. So you should

1. cycle through all opened windows,
2. grab the one you need by finding a keyword in its caption,
3. activate it
4. send the keys
5. issue a Doevents
6. get the focus back home.

Something like that:
= = = = = = = = = = = = = = =
For Each MyTask In Tasks
   If InStr(MyTask.Name, "key word") > 0 Then
       MyTask.Activate
       WasActivated = True
   End If
Next

If Not WasActivated Then
   MsgBox "Window not found"
   Exit Sub
End If

SendKeys "%f"
DoEvents

Application.Activate

= = = = = = = = = = = = = = =
Cheers,
Yves Champollion
yves@champollion.net

Hi Ed:

Karl is right- the SendKeys method tends to be querky. The only time I've
used it is in the Palm programming environment and once in MS Word when I
wanted to send information to OneNote, which as you know, is a great program
that continutes to lack VBA.

Here's how I used the SendKeys to sent off a Tab event-

strpath = "c:\program files\microsoft office\office11\onenote.exe"
strswitch = " /new C:\onenoteimport.one"
strcmd = strpath & strswitch
Shell strcmd, vbMaximizedFocus

TextBox2.Copy

strswitch = " /paste"
strcmd = strpath & strswitch
Shell strcmd, vbMaximizedFocus

SendKeys "%{TAB}", True

Application.Selection.SetRange Start:=Selection.Start,
End:=ActiveDocument.Content.End
Application.Selection.Copy

strswitch = " /paste"
strcmd = strpath & strswitch
Shell strcmd, vbMaximizedFocus

Cheers,
Al