Skip to Content
0
Oct 02, 2007 at 12:24 PM

Excel Integration with OLE - Problem with PageSetup

441 Views

Hello People,

i have a problem with OLE. Can someone help me?

I want set the FitToPagesTall and FitToPagesWide property of the PageSetup Object to 1 and 100. Also i had to set the Zoom Property to False.

http://msdn2.microsoft.com/en-us/library/aa195038(office.10).aspxhttp://msdn2.microsoft.com/en-us/library/aa195038(office.10).aspx">http://msdn2.microsoft.com/en-us/library/aa195038(office.10).aspx>

  SET PROPERTY OF obj_xls_pagesetup 'Zoom' = 'False'.
  SET PROPERTY OF obj_xls_pagesetup 'FitToPagesWide' = '1'.
  SET PROPERTY OF obj_xls_pagesetup 'FitToPagesTall' = '100'.

But this code do nothing. In the VBA Editor runs it.

Thank you for your help.

Greetings

Alex