Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
VFP6 and Excel
Miscellaneous
Thread ID:
00806542
Message ID:
00806542
Views:
77
Hi

With a lot of help from Cetin Basov I have managed to get VFp to populate an existing Excel spreadsheet. It works fine on one machine running Win2k prof sp5, VFP6 sp5 Office 2000 but not on others with a similar spec. If I run it on a machine which has Excel 97 instad of Excel 2000 it works fine otherwise I get the message

OLS is not an object.

The code is

this._webBrowser41.Navigate2('file://j:\global\mertest.xls')
oXLS = thisform._webbrowser41.object.document
oExcel = oXLS.Application

Paths are correct. Dcom permissions are OK

Any bright ideas?

Thanks

Colin
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Next
Reply
Map
View

Click here to load this message in the networking platform