A lot of the work I do in Excel uses external data that’s linked to the accounting system. When I create a query, I save the username and password so I don’t have to type it in for every refresh. It’s not the most secure setup, but the convenience makes it worth the risk.
I need a way to find all of the external data tables in all the workbooks and change the username and password. That way, when they delete my username from the accounting system, they won’t be getting errors that nobody will understand. So I changed my password in Timberline (accounting software), which raises an error while I’m still here instead of after I’ve left. Whenever the error is raised, I put the owner’s uid and pword because he won’t quit and he can’t be fired. That seemed like a good plan, but there’s a catch.
I have some VBA that uses ADO (ActiveX Data Objects) to access the databases. It’s the same principal as the external data tables, but it doesn’t produce the same error. Oh, it produces an error all right, but it doesn’t present the user with the easy fix like external data tables do. The uid and pword are hardcoded in the VBA and need to be changed there.
My quest, therefore, is to track down every workbook that has a macro with the text “uid=dick” in it. I know there are plenty out there, but I don’t know how to find them. Windows Search turns up nothing. Copernic desktop also finds nothing. Does anyone know how I can identify these files?
As an aside, I wonder if the new XML format will make this kind of thing easier?