Excell Problem

[Stewart531]

I'm trying to send a string into a cell. The string contains a date of the form xx/xx/xx xx:xx AM/PM. The problem is that vb treats the xx/xx/xx as an operation, and sends a decimal to the cell in the spreadsheet. Here is an example of the code:

msobj.Cells(1, 1).Value = strDate

I'm pretty sure this is happening on the vb side because I set the column's properties to "text only". Any ideas? Thanks.

 

[Stewart531]

Nevermind, I figured out my problem. My code was actually:

msobj.Cells(1, 1).Value = rs!Date

It seems like I couldn't assign a value from a record in a table directly into the cell. I just added these lines of code and it now works:

dim tempstring as string
tempstring = rs!Date
msobj.Cells(1, 1).Value = tempstring