Hi,
I have hundreds of Excel files spreadout over some network folders. Some of them might connect to SQL and some of these to a specific DB that needs to be moved to a new server. Is there a way to scan the Excel files to find which one has a connections to the DB? I don't want to over each one and verify each connection. I'm looking for a way to check every files without having to open them. A script, or something. Anybody ever had to face this problem?
Thanks for your help.