Hello: I wanted to know if anyone knows if it's possible to set my connection properties for the file and string to point to the relative path verses the absolute path?

e.g. If I go up to the top menu, and click on Data tab -> connections -> properties -> definition tab.....

connection file is: C:\Shipping\MS QUERY\SHIPDatabase.xlsb

but I would rather it just be: MS QUERY\SHIPDatabase.xlsb because I want my users to be able to place this folder anywhere they want on their machines.

Is this possible? I also have the same issue with the connection string.....

Thank you for your help.

Proctor