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

Problem with ExportAsFixedFormat in Excel 2007
 

Hello Robert,

The ExportAsFixedFormat method did not provide such argument to print to
PDF.

I will consulting internal team for any workaround. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with ExportAsFixedFormat in Excel 2007
 

Isn't that exactly what it is for ?

According to:
http://msdn2.microsoft.com/en-us/library/bb238907.aspx

The ExportAsFixedFormat method is used to publish a workbook to either the
PDF or XPS format.
Version Information
Version Added: Excel 2007

NickHK

"Wei Lu [MSFT]" wrote in message
...
Hello Robert,

The ExportAsFixedFormat method did not provide such argument to print to
PDF.

I will consulting internal team for any workaround. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

Problem with ExportAsFixedFormat in Excel 2007
 

Thanks a bunch!

"Wei Lu [MSFT]" wrote in message
...
Hello Robert,

The ExportAsFixedFormat method did not provide such argument to print to
PDF.

I will consulting internal team for any workaround. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

Problem with ExportAsFixedFormat in Excel 2007
 

Hello Robert,

I would like to get the screenshot of your issue. The page setting should
effect the size for the ExportAsFixedFormat. Please send me the screenshot
to understand this issue more clearly.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with ExportAsFixedFormat in Excel 2007
 

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with ExportAsFixedFormat in Excel 2007
 

If you'd be so kind as to drop me your e-mail address, I'll send the samples
over to you. The addr's I tried all bounced :)

robert at blackcastlesoft dot com


"Wei Lu [MSFT]" wrote in message
...
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

Problem with ExportAsFixedFormat in Excel 2007
 

On 25 Mag, 12:23, (Wei Lu [MSFT]) wrote:
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Hello Wei Lu,
I'm having a similar problem, related to ExportAsFixedFormat: I have
an Excel file, where I set a print area. Exporting to PDF from within
Excel correctly prints out the selected area. Saving the file and
programmatically ExportAsFixedFormat to a PDF seems to ignore my print
area, even if I put the false flag on IgnorePrintAreas parameter. Is
this known? Maybe I have also to set print area programmatically?

Thanks in advance.

Matteo

Problem with ExportAsFixedFormat in Excel 2007
 

Hello Matteo,

Robert just email me that he resolved this issue by reinstall the system.

It seems this issue related with some machine configuration.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with ExportAsFixedFormat in Excel 2007
 

The tipical MSFT workaround..

Thanks, anyway!

mt

On 18 Giu, 10:42, (Wei Lu [MSFT]) wrote:
Hello Matteo,

Robert just email me that he resolved this issue by reinstall the system.

It seems this issue related with some machine configuration.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.