Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with ExportAsFixedFormat in Excel 2007
I have a fairly large worksheet in which I've set the page setup such that
it will fit 1 pages wide and 1 pages tall. The greyed out zoom level for this sheet is 25% When I select ExportAsFixedFormat, the resulting PDF is 44in x 34in in size, scaled up exactly 4 times the size of the 11in x 8.5in landscape mode it was originally intended for. So it rather looks to me like the zoom level isn't being accounted for when I call ExportAsFixedFormat from my application. So my question is ... When I set the PageSetup object to fit 1 page high by 1 page tall, and the Zoom property is now "False" -- how can I determine what the zoom level will be when its printed? Obviously Excel does it, because it shows you the greyed out value -- but I don't see any obvious way of fetching it or computing it myself. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
Problem with Excel 2007 | Excel Discussion (Misc queries) | |||
ExportAsFixedFormat for Multiple Sheets in a Single Excel File | Excel Worksheet Functions | |||
Excel 2007 VBA problem | Excel Discussion (Misc queries) | |||
Excel 2007 Problem | Excel Programming |