| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call an XLS that is one directory €œUP€ from where the VBS file is?
How do I call the XLS that is one directory €œUP€ from where the VBS file is
located? (VBS is located in a subdir) I tried === XLApp.Workbooks.Open "..\RaceBetting.xls" === but that did not work. RaceBetting.vbs: ----------------- Dim XLApp Dim XLWkb Set XLApp = CreateObject("Excel.Application") XLApp.Visible = true XLApp.Workbooks.Open "RaceBetting.xls" XLApp.ActiveWorkbook.RunAutoMacros 1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call an XLS that is one directory €œUP€ from where the VBS file is?
How do I call the XLS that is one directory €œUP€ from where the VBS
file is located? (VBS is located in a subdir) I tried === XLApp.Workbooks.Open "..\RaceBetting.xls" === but that did not work. ChDir ".." arno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| Directory/File movement with VBA | Excel Programming | |||
| Combine all text file in directory into one file. | Excel Programming | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
Hybrid Mode
