Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Object throws error
Message
 
To
22/11/2002 01:36:54
Amit Abhangrao
Charmi Software Exports
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00725197
Message ID:
00725714
Views:
20
Interesting to know what caused the difference. Do you have default visible=.t. in one case and visible=.f. in another? Or in one case you get a warning on the screen (set DisplayAlerts = .t. to see it)?


>hi Mr. Yuri Rubinov
>
>thank you very much.. it's working fine, thank u very much..
>
>Saji
>
>>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
Reply
Map
View

Click here to load this message in the networking platform