Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE with Excel - I'm stumped
Message
From
27/06/2003 09:53:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00804575
Message ID:
00804659
Views:
61
This message has been marked as the solution to the initial question of the thread.
>Cetin
>
>I changed machines and its working. How now do I populate the spreadsheet with data from VFP code?
>
>Thanks a lot so far - you have great patience!
>
>Colin

Glad :)
Populating the spreadsheets could be done in many ways. For small amount of data (and within 65536 recs sheet limit) you could simply do :
lcTempFile = sys(2015)+".txt"
copy to (lcTempFile) delimited with TAB
_cliptext = filetostr(lcTempFile)
erase (lcTempFile)

oExcel.ActiveWorkBook.ActiveSheet.Range("A1").PasteSpecial()
_Cliptext = "" && Empty clipboard
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform