How to get size of a given variant var?

[Scott Juranek]

Just wondering if anybody has a routine or knows of a function that will let me know how many bytes a variant variable is taking, or how many bytes the 'variable' part of the variant is taking? (Any then I'll add the fixed portion). Thank you...

[srinath]

The size of the variant depends on what type it contains. so first access the type in the
the variant structure. then you can easily determine the size of the variable

[Scott Juranek]

Thanks. I knew that much but I figured someone may have written a generic function to do this. I guess I'll write one up, although I'm only handling a few different types of variants so it will be limited.