Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Object throws error
Message
 
To
21/11/2002 10:15:44
Amit Abhangrao
Charmi Software Exports
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00725197
Message ID:
00725213
Views:
13
Try:
...
obExcel.visible=.t.
obExcel.DisplayAlerts = .f.
obExcel.Dialogs(8).Show
...

>hi,
>
>I am using excel COM component to print my .HTML file, which is generated by the VFP 6.0, by using the following statements.
>
>obExcel = CreateObject("Excel.Application") && Creates Excel Objects
>obExcel.WorkBooks.Open("C:\Test.Htm") && Opens the HTML file
>obExcel.Dialogs(8).Show && To Activate the Print Dialog
>
>here the first two statement succeeds without any error message. But the third statement makes my machine in a hang mode. My VFP version is 6.0 (06.00.8167.00), and My Excel 2000 version is (9.0.3821 SR-1). If the excel version is 10.x.x or above these commands executes without any interruption and fine. If any solutions please let me know on sajinair76@yahoo.com
>
>Thank you
>
>Saji
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform