Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo to Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Memo to Excel
Miscellaneous
Thread ID:
00294311
Message ID:
00294311
Views:
63
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.
Next
Reply
Map
View

Click here to load this message in the networking platform