View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Jordan Charles Jordan is offline
external usenet poster
 
Posts: 56
Default Problem opening .htm file from Excel 2000

Hi. I am having a problem, I think in migrating an application which
is successful on one PC (PC "A", running Windows ME) to another PC
("B" running Windows XP).

(1) On PC "A" we have developed an Excel 2000 file which in all
respects works fine. In particular, as a menu option, it will open an
..htm help file that I wrote and saved in Word 2000 (of about 100 kb).

(2) I then wrote an install programme in VBA which successfully
creates a folder hierarchy on "B" , and copies .xls, .gif, .xla files
from a CD, all installed in the correct places. In all cases I used
Easy CD creator to copy the files to the CD. The install programme
programme on the CD, "Setup.xls" , then copies all the files.

(3) On PC "B", the workbook fires up just fine, but when we press the
help file menu option, it fails to start up Internet Explorer, and
thus present the Help file. The 2 lines of code in question a-

..URL = "C:\Data\Htm\Chapter1text.htm"
X = Shell("start " & URL, 2)

Given that this code works fine on PC "A", and not on "B", it makes me
think that some files or links are not getting copied from "A" onto
the CD, so that the Shell command is failing. Or does Shell not work
in Windows XP ?

On PC "B", the file list appears to be exactly the same, and in the
same folders as on "A" and includes:-

Header.htm
filelist.xml
and many image.gif files (about 40).

It it therefore possible to move this application simply by copying
fles with Easy CD Creator, as I have done ?


Thanks in advance - I have a large number of students due to get the
whole install in about 10 days time ! Charles Jordan