I currently have a workbook that has several Query Tables in it. I currently
have a macro to "refreshall" but my problem is that occasionally the file
name may change causing an error in the refresh process. Is there a way to
include a procedure in code that if the filename in the query no longer
exist, it could prompt for the correct filename? In my existing macro I have
a section for inserting new queries & it prompts for the filename but I'm not
sure how to code on a refresh error to prompt for a filename.

Any help would be greatly appreciated.

Maybe instead of refresh all refresh each in turn with an on error goto

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chas" wrote in message
...
I currently have a workbook that has several Query Tables in it. I
currently
have a macro to "refreshall" but my problem is that occasionally the file
name may change causing an error in the refresh process. Is there a way
to
include a procedure in code that if the filename in the query no longer
exist, it could prompt for the correct filename? In my existing macro I
have
a section for inserting new queries & it prompts for the filename but I'm
not
sure how to code on a refresh error to prompt for a filename.

Any help would be greatly appreciated.