How do i return a collection's values, instead of by reference

[granni]

I have a private collection in a bas module, now i have a function that returns this col

Public Function GetOldRD_Col() As Collection
Set GetOldRD_Col = mcolOldRD
End Function

it happens that the returned collection is a reference to the private collection, which i dont want.

I need to return the collection by value

Can anyone help?

 

[culshaja]

As a collection is an object there is no way to do this inbuilt into VB. You would have to right your own 'Clone' routine that would clone the orginal collection onto a new one that you have passed into the property/method, or pass back a newly created cloned collection.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[granni]

owh, but thanks, i figured as much

 

[venom3249]

try using the rtlCopymemory API