Error setting EXCEL Page Orientation via COM

[SteveShanks]

Hi All

I have some code that creates an instance of Excel, adds a new workbook and sheet and then sets the orientation of the page to Potrait.

This is built on a machine with Office 2000 and the project has references to Excel Library 9 (Excel 2000) and works on various combinations of Office including 2000, 2002, 2003 etc but on one Windows 2000 Pro/Excel 2000 machine it gives the following error:

"QueryInterface for interface Excel.PageSetup failed."

Does anyone know what could be causing this, I can't find much about it on the web.

Thanks
Steve

 

[firefytr]

Hi Steve,

Can you post your code please?

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[SteveShanks]

Hi

We have patched office a bit and it seems to have got past the Page Orientation area but now errirs with 'Bad variable Type' when assigning a string to a cell.

Plan is to remove office and reinstall and take it from there.

Thanks
Steve