I want to change my query connection string that is used on one tab of a workbook and extracts information from another tab on the same workbook. In the old days this was called using a relative pathname instead of a fullpathname. The reason I want this is that I want to be able to move the file to another folder or give the file to someone else and I want the queries to still work. Here is a sample connection string.
DSN=Excel Files;DBQ=C:\Documents and Settings\moffats\My Documents\aBudget\Source.xls;DefaultDir=C:\Documents and Settings\moffats\My Documents\aBudget;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;
The other thing that I note which I don't understand is that this excel workbook is a macro enabled workbook, yet the filename has only a .xls??? Reason? The queries work fine until I move the file to another location.