I have a ton of workbooks that cannot be run under Office 2010 because they connect to a MS-Access database and the connection string in each of the workbook references the Jet 4.0 engine.
What I need is way to scan these workbooks and replace the Jet reference to the newer ACE 12.0 reference. There are just too many to do this one by one. I have tried to figure out how to get to the VBA code programmatically but without success. Anyone have any thoughts or solutions?
Bookmarks