I have a VBA application which requires an additional Excel file called Configuration.xls; as the name implies, it holds info about each user. Right now, I simply open it from the same directory where the application is located. However, if I happen to move the application to another directory (or if I'm in a network environment), the application can no longer find the configuration file.

My solution so far has been to create an additional file in the C: root directory (which everybody has for sure), namely C:\ConfigPath.xls, which points to the directory where Configuration.xls is to be found. This file is only searched if the configuration file is not found in the application directory.

However, I'm sure there has to be a better solution (one that is not sensible to the user, for instance, erasing the file). Any ideas?