If you are encountering this issue, it is most likely because you have not added the CData Excel Add-In as a reference in your Visual Basic module/script. To add the CData Excel Add-In as a reference, please follow these three simple steps:
Once you have opened VBA, navigate to Tools -> References.
Locate the CData Excel Add-In, check the box next to it, and then click OK.
Run the script, and the error will no longer occur.
If this solution does not resolve the problem, please feel free to reach out to our support team at email@example.com for further assistance.