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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Stuart" wrote in message ...
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