I've exported memos from vfp6 to Excel97 using OLE and
cell(i,j).value = table.memo
This part is no problem. However, once the memos are in Excel, they do not show up except for the first few words in a column - and most of them are full paragraphs. If you click on an Excel cell, the entire memo text shows up as a tooltip. That's okay, except that the user can't print or copy them.
Any ideas on how to get around this problem? Do I need to format the memo in vfp, or is there a way to wordwrap the excel column? I've tried various Excel formats to no avail.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.