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 support@cdata.com for further assistance.