Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String to Variant conversion
I am using Harlan Grove's PULL function to grab data from other
spreadsheets, and it mostly works except that some strings that look like dates get converted to numbers and therefore don't work with VLOOKUP and the like. For example, "06-6107" gets changed to 1536728. It seems that this is happening in this bit of code: For Each c In r c.Value = xlapp.ExecuteExcel4Macro(b & c.Address(1, 1, xlR1C1)) Next c The Value property is a Variant, so in the conversion the string is interpreted as a date. Is there any way to force that to be converted a Variant/String instead of Variant/Double? Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
String to Variant incorrect conversion | Excel Worksheet Functions | |||
DIM Variant / String | Excel Programming | |||
Retain Variant / String value | Excel Programming | |||
basic variant to array conversion | Excel Programming | |||
Variant to String | Excel Programming |