Hi!
Ive made a report (A.xlsx) which ive connectet to B.xls, C.xls and D.xls in the sheets using Query from excel files.All files are in the same folder. It all works fine, untill i try to move the workbooks to other folders. I know in HTML you could use //filename.xls so it would look in the same folder you currently "are" (sorry for the english). Are there any similiar code i could use under connection Properties -> Connection string and Command text instead of e.g C:\folder\filename.xls, so it will search in same folder as A.xlsx?
Bookmarks