Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FIND CURRENT DIRECTORY
Find Current Directory:
On a CD I have 4 files. AUTORUN.INF, EXCEL1.VBS, SETUP.ICO, and INSTALL.XLS. The code is shown below. When I insert the CD, I want the CD to automatically open and then automatically open INSTALL.XLS. When I insert the CD, this error message appears: €˜Install.xls could not be found. Question: How do I show in the code that the Install.xls file is on the CD? What code do I need to add to EXCEL1.VBS to show the CD Current Directory ? See Below: 1. AUTORUN.INF [AutoRun] OPEN=EXCEL1.VBS OPEN=SETUP.ICO 2. EXCEL1.VBS Dim objXL Set objXL = WScript.CreateObject("Excel.Application") objXL.Visible = TRUE objXL.Workbooks.open("Install.xls") 3. SETUP.ICO 4. INSTALL.XLS -- Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FIND CURRENT DIRECTORY
Hi,
What code do I need to add to EXCEL1.VBS to show the CD Current Directory ? Try: Application.Path (works in vba) Regards, Gijs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open file in current directory | Excel Worksheet Functions | |||
current directory | Excel Discussion (Misc queries) | |||
Current Directory | Excel Discussion (Misc queries) | |||
changing current directory to that of the current open file | Excel Programming | |||
Set The Directory to the Current WB Path | Excel Programming |