>>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.
>
>This is just a guess, but would setings like MEMOWIDTH when you export have any effect on this?
It may, but I think it will cause split words. I'll check it out before I implement Cetin's code, though.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.