Signature (Visual Basic / VBA)
Public Function VariantStringToVariant( _
ByVal vValue As Variant _
) As Variant
Code Example
Assuming
Dim strIntTwo As String
strIntTwo = Chr$(2) + Chr$(2) + Chr$(0)
Dim strLngTwo As String
strLngTwo = Chr$(3) + Chr$(2) + Chr$(0) + Chr$(0) + Chr$(0)
for example
VariantStringToVariant(strIntTwo) = 2%
VarType(VariantStringToVariant(strIntTwo)) = vbInteger
VariantStringToVariant(strLngTwo) = 2&
VarType(VariantStringToVariant(strLngTwo)) = vbLong
Parameters
| Parameter | Description |
|---|---|
| vValue | The string containing the internal representation of some value along with the type of the value. Function returns an empty string vValue is an empty string. |
Notes & Version History
| Summary | This function will convert a string created by the VariantToVariantString function back to its original value and data type. |