I almost follow you...could you elaborate a bit more? I may be making
wrong assumptions about how your example works.

Thanks

B


"Edward Ulle" wrote in message
...
You may not have to do anyting.

If your data is type String then Excel will coerce into the correct data
type. For example:

strDate = "2.14"
wsWorksheet.Range("A1").Offset(1,1) = strData will yield floating point
number 2.14 in the cell.

strData = "200"
wsWorksheet.Range("A1").Offset(1,1) = strData will yield a general
number 200 in the cell

strData = "Hello"
wsWorksheet.Range("A1").Offset(1,1) = strData will yield the text Hello
in the cell

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!