B
BillJ
(i'm using Visual Studio 2005 and Excel 2003 -- cross posted in vc.mfcole
group)
i have read that Excel 2003's char limit for a cell is 32,767 chars, of
which only 1024 are displayable in the cell (the remainder are visible in the
expanded command line (or whatever it's called...at the top of the
worksheet)). that's fine.
however, i have text that is 1405 chars and Range.put_Value(str_1405) fails
unless i set str_1405 = left(str_1405, 910). the actual max value is
somewhere between 910 and 925.
since i'm well below the 32,767 limit i feel this should work. has anyone
else run into this? suggestions?? i've tried Range.NoteText(vStr, vStart,
vEnd) and it always fails w/ "type mismatch). i've tried
Range.AddComment(vStr) - it fails like NoteText, although i'm not sure that a
Comment is the same as a Note.
tia
group)
i have read that Excel 2003's char limit for a cell is 32,767 chars, of
which only 1024 are displayable in the cell (the remainder are visible in the
expanded command line (or whatever it's called...at the top of the
worksheet)). that's fine.
however, i have text that is 1405 chars and Range.put_Value(str_1405) fails
unless i set str_1405 = left(str_1405, 910). the actual max value is
somewhere between 910 and 925.
since i'm well below the 32,767 limit i feel this should work. has anyone
else run into this? suggestions?? i've tried Range.NoteText(vStr, vStart,
vEnd) and it always fails w/ "type mismatch). i've tried
Range.AddComment(vStr) - it fails like NoteText, although i'm not sure that a
Comment is the same as a Note.
tia