How to convert Variant to Byte Array?

[Markus W.]

Is there a way (beside doing it in a loop value by value) to convert a variant, which contain an array of byte data, to a byte array?

[WizBang]

Yes. Declare a dynamic Byte array, and use StrConv().

[Vi2]

Dim b, a() As Byte, aa() As Byte
  
  ReDim aa(2) ' Source byte array
  aa(0) = 11
  aa(1) = 2
  
  b = aa ' Store byte array into variant
  
  a = b ' Store variant with byte array into byte array

[Markus W.]

Thank you both for reply!

WizBang, my data is not a string. All values for strconvs' 'conversion' argument seems to change the content of the byte array - right?

Vi2, using an 'undimed' dynamic array does it :-) (unfortunately I tried with a 'dimed' one before)

[WizBang]

You can use StrConv() to accomplish your goal, but I'm not sure what you mean by "change the content of the byte array". It can fill the Byte array with the contents of the Variant, but the the array must not be ReDim'd first.

Obviously the method posted by Vi2 can work, though I seem to recall certain cases where I needed to use StrConv(). Off hand I don't recall the specifics, so I can't say whether it has any bearing on your particular need. I never use Variants (too slow), so perhaps that's what the difference was.