Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and Excel
Message
 
To
04/07/2003 03:01:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00806542
Message ID:
00806882
Views:
15
Cetin

Thanks - that moves me forward

Now when I click on the button it brings up the file download dialogue. The control I put on the form was done by adding an activex control from the toolbar) then when the dialogue came up adding a microdoft web browser control. Have I added the wrong control?

Colin

With thisform.OleControl1
.Navigate2('file://c:\global\mertest.xls')
Do While .ReadyState # 4 && Wait for ready state
EndDo
endwith

oXLS = thisform.OleControl1.object.document
oExcel = oXLS.Application
* Test setting column A,B to red
oExcel.ActiveWorkbook.ActiveSheet.Range('A:B').Interior.ColorIndex = 3


Thanks


Colin
Specialist in Advertising, Marketing, especially Direct Marketing

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

Click here to load this message in the networking platform