[RESOLVED] [VBA / VBScript] Dictionary Object with Custom Data Type
I wasn't sure whether to post this here because I'm using VBA or in VBScript because that's where the dictionary object is being imported from.
I'm trying to use the dictionary object to be of type string, ColumnData. However, trying to add the ColumnData type to the dictionary causes the error:
"Only user defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions."
I originally had ColumnData defined as Private Type in a Private Class module. Based on the error I tried changing this to a PublicNotCreatable Class, however this gives an error. Finally I tried moving the Type to a module and defining it as Public, but that doesn't work either.