Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell Problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell | Excel Programming | |||
shell commands | Excel Programming | |||
VBE COM Add-in Shell | Excel Programming | |||
Problem using Excel's "Shell" command | Excel Programming | |||
Shell | Excel Programming |