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 protected] for further assistance.
