The Database Class is not supported in Excel from Office 365? Works in Excel 2016.
The Database Class is not supported in Excel from Office 365? Works in Excel 2016.
Perhaps this is a problem similar to this
https://www.excelforum.com/excel-programming-vba-macros/1320782-vba-error-class-not-registered.html
They were using DAO 3.6 which had to be changed to the Microsoft Office 16.0 Access Database Engine Objects library instead.
5 people are following this question.