$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

2011-09-09 Thread Stuart Redmann
On 7 Sep., ShayneH wrote: > Is there a way to expose an array that is enclosed by a variant? > Basically I have one function that returns a variant type which needs > to be passed to another procedure that requires the parameter to be > typed as a byte array. > > eg: > Function UsuallyReturnsAnA

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

2011-09-07 Thread GoldenLance
You cannot reference a variant array using a byte array even if the data contained within the variant array is all byte. Suggest using Sub ConsumesByteArray(ByRef ByteArray) On Sep 7, 3:26 pm, ShayneH wrote: > Is there a way to expose an array that is enclosed by a variant? > Basically I have on