Search:   Namespaces Discussions .NET v1.1 Feedback

Excel & C# questions Messages   Related Types This message was discovered on microsoft.public.dotnet.framework.interop. Post a new message to this list... Terry I am creating a C# app to generate an Excel file and I have a couple of questions. First I can't get the Zoom option to work. I have an Excel sheet define as oSheet. This line : oSheet.PageSetup.Zoom = 75; doesn't do anything. I get no errors but when I open my Excel file, the zoom is still set to 100 %. What is wrong. Also, Under PageSetup, I need to set the Scaling to 60% of Normal Size. I don't see anything under .PageSetup for this. Terry Reply to this message...        Terry Well, I figured out part of my problem. The PageSetup.Zoom changes the Scaling. So that problem is resolved. I thought it would change the View/Zoom. So, what is the C# equivalent to changing the View/Zoom in Excel? Terry "Terry" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...        Terry Resolved my other problem. To change the View/Zoom, user ActiveWindow.Zoom Terry "Terry" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...     Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com