Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB directing IE to a local site's html page
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB directing IE to a local site's html page
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export data from Excel to a local web page | Excel Discussion (Misc queries) | |||
Can a chart reference the local page | Charts and Charting in Excel | |||
VBA to save a web page to local disk | Excel Discussion (Misc queries) | |||
Reference styles and local/non-local formulae - international problems. | Excel Programming | |||
open/save excel on a local web page as an activex | Excel Programming |