Hi,
I need to open file in my apps directory, like the following:
Problem is that if the file is in ROOT directory, I'll get an errorCode:Set wbkWorkbook = objExcel.Workbooks.Open(App.Path & "\" & "Orders.xls")
because of the slash between App.Path & the "Orders.xls".
How can I test if my file is in the root directory or not, and what's
the correct syntax for fixing this problem.


Reply With Quote