Hi,

I am using Excel, Internet Explorer, and Visual Basic to create an academic
demonstration. I want to reduce the demonstration to a CD that I can port to
any Windows machine and, using that machines Excel program, perform the demo
for the owner of that computer. This means that I cannot anticipate the drive
letter associated with the as-yet-unknown computers CD drive.

I need advice on the VB code for a subroutine to be invoked by clicking a
button in an Excel workbook. When that button is clicked, I want to €¦

1. Create an Internet Explorer Application.

2. Direct the Explorer to navigate to a given html page that is resident on
the CD.

The html will be part of a complete FrontPage website that will be in the My
Webs folder on the CD. All the links and references within the local site are
relative.

I can make this work in terms of causing the Explorer to navigate to the
site as it resides on the wwweb; but cannot figure out what to do when the
site is on the same drive as the workbook.

Thanx

Amy