Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export Memo field in Excel
Message
From
11/08/2003 06:55:30
 
 
To
11/08/2003 04:53:04
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00818809
Message ID:
00818824
Views:
16
Well,

You can try a automation solution: Copy the strin into clipboard then paste it in a new excel sheet.

try this:

_cliptext=MyMemoField
oExcel = CreateObject("Excel.Application")
oExcel.Visible = -1 && for debugging
oexcel.WindowState = -4140

oExcel.Workbooks.Add()
oSheet = oExcel.ActiveSheet
lcCell = 'A1:B2'
oSheet.Paste( oSheet.Range( lccell ) )
oexcel.WindowState = -4137

Lccell is the range of cells where You want to paste. If there is going to be a messagebox telling U that the range does not corespond with the clipboard or something like that please corect lcCell.

Good luck,
ionut
Please help us raise more code

www.hotscripts.ro
Previous
Reply
Map
View

Click here to load this message in the networking platform