Excel Add-In: “Compile error: User-defined type not defined” when running VBA script.

  • 5 October 2023
  • 0 replies

Userlevel 2


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: 

  1. Once you have opened VBA, navigate to Tools -> References. 




  1. Locate the CData Excel Add-In, check the box next to it, and then click OK. 




  1. 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. 

This topic has been closed for comments