Casting variables

[Harvey]

Simple question, but yet I found no answer.

I have a function that returns an object. The object is of the class clsCompany, but it is returned as Object. I can access all the values and functions in it, but I would like to store it in a clsCompany variable again. How can I do that?

 

[Harvey]

Hi people,

Tushar,
I have tried your solution but when I try to set a class to publicnotcreatable I get an error 380: "Invalid property value."
Also, I cannot think of any way to copy the data when I have the class modules in both workbooks, since I am using a lot of Collections. While I can seem to cast the supermanager by putting it into a collection before exporting, every other instance of any class that is inside a collection is cast to (Object) automatically. I am really stuck here. Should I post my code?

Greg,
Have you fixed your problem already? I have had similar problems when I created OLEObjects in a worksheet.

Thanks for all the comments and help so far,
Regards,

Martien