Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field to excel
Message
From
25/04/2007 09:48:19
 
 
To
25/04/2007 09:36:36
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01219676
Message ID:
01219738
Views:
23
This message has been marked as the solution to the initial question of the thread.
Basically, memo value could be transferred to Excel by following way:
cMemovalue=mytable.memofield
oExcel=CREATEOBJECT('Excel.Application')
oExcel.workbooks.add
WITH oExcel.workbooks[1].activesheet
	for nLoop=1 TO MEMLINES(cMemovalue)
		.range('A'+TRANSFORM(nLoop)).value=MLINE(cMemovalue,nLoop)
	endfor
endwith
oExcel.visible=.t.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform