OS: 64 bit
Microfosoft Office 2007: 32 bit
Use VBS, ADODB to connect to excel file, got error: "Provider can not be found"
Solved:
- Step 1: Download Office Microsoft Access Database Engine 2010 Redistributable
AccessDatabaseEngine_x64.exe
- Step 2: Run downloaded file with following option "AccessDatabaseEngine_X64.exe /passive"