ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Compile error: User-defined type not defined #3

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Receiving this error image There seems to be issues with early binding and Microsoft XML, v6 or Microsoft XML, v3 see: https://stackoverflow.com/questions/46682798/error-when-using-microsoft-xml-v3-0-or-v6-0

This line causes the error and is what requires Microsoft XML: Dim oHTTP As New XMLHTTP in Function RCHGetURLData1 (module smfUtilities_) RCHGetURLData, RCHGetURLData2, RCHGetURLData3 use other methods.

ClimberMel commented 1 year ago

Using Microsoft XML, v3 with all versions of the SMF Add-In will work and prevent this issue. I have bundled new versions of the add-in RCH_Stock_Market_Functions-2.2 with this reference.
This is now considered resolved.