Find xls with embedded queries

B

boreal

I am looking for a way a way to search my fileshare and find all xls files
that have MS Query queries embedded.

When we create queries in Excel we do not save the queries as external files
(DQYs). So, unfortunately I cannot just search for all DQYs and return a
corresponding list of xls filenames.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking limit values from separate xls file 0
Web query 2
Command line used for opening .xls files and clicking abutton/running a function. 1
MS Query 7
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10
Two Saves for one event (sheet1.xls) 2
Format Cells dialog is not displayed when file generated with XLS 0
Sub projects added as read only in Master file which are saved on sharepoint 1

Top