View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Open file with VBA

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