I'm trying to use the DA Grids spreadsheet, but I'm getting a run-time error "Class not registered" for the code step below. I didn't see this issue brought up on here before. Any thoughts on getting around this? The RAM SS version is 17.01.01.05.
'Initialize DataAccess Set RAMDataAcc1 = New RAMDATAACCESSLib.RamDataAccess1
If you are using a 32 bit version of Excel and version 17.00 or 17.01 you might have such an error.
Apparently I am running 32-bit. I've used other DA API's before without any problem, like with the Model Merge spreadsheet. Is there a way around this specific call? It would be helpful for us to implement this spreadsheet.