I am trying to use vba to launch a file (external application) and
when it has launched press F9. My code below launches the file and it
is visible but it doesn't hit F9. When I look at my taskbar it is the
spreadsheet that looks like it is active rather than the external app.

Code:

Sub OpenDashboard()

Dim dReturnValue As Double
dReturnValue = Shell("C:\Program Files\PRISM Europe\Dashboard
\dashboard.exe G:\isosbsm\BST Service\Proactive Service Management
\Wincharts\LPAS Dashboard.dsh")
AppActivate dReturnValue
SendKeys "{F9}", True


End Sub




Does anyone have any ideas?
Thanks