How to test if an excel sheet has an external query?

[sazmeise]

I have an excel file which reads a list of filenames and opens each file, refreshes the external data query saves and closes the file.

If one of the files in teh list of filenames does not have a query to refresh an error occurs.

How would i test if a spreadsheet has an MSQuery associated with it?

Thanks
Saz
***

ray:

 

[sazmeise]

PLEASE IGNORE

PLEASE IGNROE PREVIOUS THREAD.. I'M IN WRONG FORUM!