If you click OK, Microsoft Query should open, and you can edit the
source file name in the SQL string.
Carl wrote:
I am trying to edit a query in an Excel worksheet to change the name of the
source file but keep getting the message, "Query wizard cannot be used to
edit this query". The worksheet is not protected. Does anyone have a
suggestion? Thanks in advance.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html