Fred,
I wish Rob Bruce would show up in these groups more often...
'----------------------
'Rob Bruce - public.excel.programming - 05/26/2005
'If you use the shellexecute API you don't need to know anything about the app:
'(just the file path and file, as the API determines the program to use - JBC)
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Sub OpenFileInDefaultApp(FullName As String)
ShellExecute 0, vbNullString, FullName, 0&, 0&, 1
End Sub
Sub test()
OpenFileInDefaultApp "C:\WINDOWS\Help\iexplore.chm" 'JBC
End Sub
'-------------------------------
Regards,
Jim Cone
San Francisco, USA
The Shell command doesn't seem to work with a help file. What command will
run a help file and then return to the XL app?
Thanks,
Fred
