Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing XLS from VFP OLE Error
Message
 
 
To
27/10/2009 17:07:30
Hong Yew
People Quest
Malaysia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01431759
Message ID:
01431762
Views:
32
>Hi all
>
>I tried to print a XLS worksheet but encountered the following error
>
>OLE Dispath Error: Unable to get Printout property of worksheet class
>
>My codes as follows
>
>oXLS=CreateObject('Excel.Application')
>oXLS.Workbooks.Open(....)
>oXLS.ActiveWorkBook.Sheets(1).Activate
>oXLS.ActiveWorkbook.Sheets(1).Printout
>
>Your advice much appreciated
>
>Thanks & Best Regards

I've tried it and it worked for me (Excel 2007).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform