Call an XLS that is one directory “UP†from where the VBS file is?

C

CRayF

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
 
A

arno

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
Click to expand...
work.

ChDir ".."

arno
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBS starts Excel. How to point to different macro when run? 3
Passing parms to a VBS file or a macro when executed? 4
How to pass parameters to excel from wscript (Windows script) 5
Is there a way to test first if MySampleAll.xls is already open 4
Rename Excel file via VBA 2
How to Cancel the Protect of Excel with VB and save it with a new password again 1
Open a New Instance of Excel 3
Open password protected excel file 2

Top