Easy One - VBA Macro causes Excel to !VALUE# with more than 255 character string

[recarv]

the offending code is the following:

ws.Range(Cells(i, 4), Cells(i, 4)).Value = VBA.CStr(rst!comments)

where rst!comments is a field of type mediumtext in a mySQL database. rst is an ADODB.Recordset

and the len of Cstr(rst!commments) is > 255.

does this help

[RobDog888]

Maybe try using the explicit property instead of relying on the default. It could be that it is
trying to place the object in the cell instead of the value.

ws.Range(Cells(i, 4), Cells(i, 4)).Value = VBA.CStr(rst.fields("comments").Value)