is there an app.path....

[Iat]

Is this the correct syntax? I tried, but it says "object required"

Workbooks.Open FileName:=Workbook.Path & "MyExcel.xls"

Please help or point me to some reading materials.

Thanks,

Iat

App.Path is a VB6 function. If your automating Excel from VB6 then its ok.

Excel also has Application.Path but its the path of Excel and not the workbook

There is the WorkBook.Path too.