how to set relative path for excel

[kamalteja]

Hi,

Below is my code:

Step 1:

Code:

Set objExcel = CreateObject("Excel.Application")

Step 2:

Code:

Set objWorkbook = objExcel.WorkBooks.Open("D:\Partner Security Program\Test_Data\InspectCustomer.xls")

Step 3:

Code:

Set objDriverSheet = objWorkbook.Worksheets("Inspect Customer")

In Step 2, I want to set the relative path like

Code:

Set objWorkbook = objExcel.WorkBooks.Open("..\ ..\Test_Data\InspectCustomer.xls")

It is prompting error saying it could not locate the file ... please let me know the exact syntax