Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE with Excel - I'm stumped
Message
From
27/06/2003 09:27:44
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00804575
Message ID:
00804646
Views:
61
>Cetin
>
>My code in the form's init is
>
>*Form.init
>this._webBrowser41.Navigate2('file://c:\downloads\mertest.xls')
>
>*Once you do this you've access to excel's object model too. ie:
>
>oXLS = thisform._webbrowser41.object.document
>
>oExcel = oXLS.Application
>oExcel.ActiveWorkbook.ActiveSheet.Range('E1:E7').Value = 'sheet1'
>oExcel.Application.ActiveWorkbook.Save()
>
>
>This is the offending line
>
>oExcel = oXLS.Application
>
>Thanks
>
>Colin

I don't know why not working for you :( Works very well for me.
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