Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
02/03/2000 11:39:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00340497
Message ID:
00340608
Views:
27
>>>VBAXL9.CHM looks like it will work for me.
>>>
>>>But I'm having a hard time just getting it started. As a test I tried the following:
>>>
>>>oExcel = createobject("Excel.application")
>>>oExcel.workbooks.open('C:\TEST\STOCK UPDATE.xls')
>>>
>>>But I get nothing...Any ideas?
>>>
>>>Many Thanks!
>>
>>Marvin,
>>
>>Have you set the Visible property to .T.?
>
>Yup, that was it Thanks!


Marvin,
Besides vbaxl9.chm recording macros in Excel is a good way to "capture" code. However it's VBA code and you should do slight modifications.
Nearly every other day there is some Excel or other OLE Automation code on UT. Check some of them for a quick start. Some of the threads :
"Word Document options" - 25th Jan, 2000
"VBA for Excel graph" - 4th Feb, 2000
"Excel Pivot tables" - 28th Jan, 2000
For modifications I suggest you to do as much as possible (e.g. changing a range of cells value based on some string manipulation) on VFP side. Excel VBA code runs awfully slow.
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
Reply
Map
View

Click here to load this message in the networking platform