Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Office Documents from FoxPro
Message
From
30/11/1998 14:44:15
 
 
To
30/11/1998 14:40:51
Thierry Yuen
Stantec Architecture Ltd.
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00162448
Message ID:
00162510
Views:
30
Hi Thierry ---

OK, after the Open method, try this:

oExcelSheet.Workbooks(1).Print

I believe that Workbooks is a collection and since you are only opening one workbook, it should be index #1.


>Thanks, John for the coding tips. Everything is good up to the ActiveWorkbook descriptor. In my Visual FoxPro 6.0, I am getting the following error: 'OLE IDispatch exception code 1000 from Microsoft Excel; Workbook does not have ActiveWorkbook property'. Of course, I believe this error results directly from Excel 95 incompatibility with this property. I'll be receiving my Office upgrade later in December. in the meantime, I'm not sure how to temporarily advert this error. If you have further suggestions, please let me know.
>
>Thanks.
>
>Thierry
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform