Possibly useful link:
Code:http:// e z i n e a r t i c l e s . com/?Using-the-Query-Wizard-in-Excel-2003&id=1451304 (removed the spaces after the two slashes and before the com - VDr would not let me paste the URL)
You may find that you have to recreate the query if you can't edit it. When I create macros for Excel that need a file location which might change, I store that information in a cell in the spreadsheet and have the macro use that data to make it easier to change. There are other places to store that information as well, depending on your needs.
You might also try posting this question in the appropriate forum at:
http://www.vbforums.com
Reply With Quote
