I am charged with accessing all Excel applications on a server programmatically checking for code and hard links to SQL Server and Oracle with hard coded passwords, i.e. looking for connection strings to external databases with hard coded passwords.
I've done this before using Access to check table links but not the VBA code by attaching external mdb tables to my database and then checking the MSysObject table connections for each table. I didn't check the VBA code for coded connections.
I really need to check the Access and Excel VBA code too with from an external program.
Any suggestions or direction would be appreciated.
Thank you in advance for your courtesies.
I've done this before using Access to check table links but not the VBA code by attaching external mdb tables to my database and then checking the MSysObject table connections for each table. I didn't check the VBA code for coded connections.
I really need to check the Access and Excel VBA code too with from an external program.
Any suggestions or direction would be appreciated.
Thank you in advance for your courtesies.
