Shell Problem

[Stuart]

Using Office 98 on XP

Having recently upgraded from win98 to xp I am having the following problem

The following line works perfectly in win98 but fails in XP

**************
Shell "start """ & Range("G1").Value & "\test.htm"""
*************

The error message is
run time 53
"File Not Found"

Cell G1 contains ... C:\Images\Preview

Note their is nothing a matter with the specified path nor the file in the
relevant folder!

Remember this works perfectly in win98

 

[David McRitchie]

Hi Stuart,
This is what I am using to open the file. It opens in Internet Explorer
for HTML files which is best to use when working with Excel. I used
to have code similar to your and it is all commented out.
Dim RC As Long
RC = Shell("Explorer " & filename, 1)

filename is a string would be c:\temp\XL2test.htm
in http://www.mvps.org/dmcritchie/excel/code/xl2htmlx.txt
which is the companion to
http://www.mvps.org/dmcritchie/excel/xl2html.htm