look at

thisworkbook.path

Tim.

--
Tim Williams
Palo Alto, CA


"Amy" wrote in message
...

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 machine's 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 computer's 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