S
Shazbot79
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
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