Thanks Martin. Otto
"Martin Fishlock" wrote in message
...
Otto,

Option explicit just requires that you delcare all variables and so that
you
need to dim retval or just remove it if you don't want to use the return.

Option Explicit
Sub TryOE()
Do, RetVal as variant
Dim s As String
s = "C:\Program Files\Outlook Express\msimn.exe"
RetVal = Shell(s, 1)
End Sub

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Otto Moehrbach" wrote:

Martin
Thanks for the help. The macro:
Option Explicit
Sub TryOE()
Dim s As String
s = "C:\Program Files\Outlook Express\msimn.exe"
RetVal = Shell(s, 1)
End Sub
returned an error "variable not defined" and highlighted RetVal.
Apparently
RetVal is not recognized.
Your help is greatly appreciated. Otto
"Martin Fishlock" wrote in message
...
Are you trying to execute this program?

If so then try the shell command:

s="C:\Program Files\Mozilla Thunderbird\thunderbird.exe"
RetVal = Shell(s, 1)
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Otto Moehrbach" wrote:

Ankur
Thanks for responding. That doesn't work. The error message says
that
the requested file is not an Excel-compatible file. The file I want
to
open
is:
"C:\Program Files\Mozilla Thunderbird\thunderbird.exe"
I tried your method also with the following: (Outlook Express)
"C:\Program Files\Outlook Express\msimn.exe"
Thanks again. Otto
"ankur" wrote in message
ups.com...

Hi Otto,

Try..

Sub test()

Workbooks.Open Filename:="C:\ThePath\FileName.xxx"

End Sub

Regards
Ankur
www.xlmacros.com


Otto Moehrbach wrote:

Excel XP & Win XP
I know how to open an Excel Workbook file.
What I want to do is open a non-Excel file when I know the full
file
name:
"C:\ThePath\FileName.xxx"
Thanks for your time. Otto