>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