Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publish as PDF/XPS Strange
I am using a macro to loop through several workbooks and publish
selected sheets to PDF. The sheets have both tables and charts and are scaled at about 85% to fit on a single page. The PDFs retain the correct print area/scaling size, the problem is the the charts seem to stay at 100% so they end up being cut-off. Below is the macro code I use. Any ideas? Sub pdf() ' ' pdf Macro ' ' Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5", "Sheet6")).Select Sheets("Sheet6").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\WORK\Template.pdf" _ , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=False End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publish as PDF/XPS Strange
Hi This is a known problem and as far as I know there is no fix Seems to be a problem with a update inside SP2 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gbruintjes" wrote in message ... I am using a macro to loop through several workbooks and publish selected sheets to PDF. The sheets have both tables and charts and are scaled at about 85% to fit on a single page. The PDFs retain the correct print area/scaling size, the problem is the the charts seem to stay at 100% so they end up being cut-off. Below is the macro code I use. Any ideas? Sub pdf() ' ' pdf Macro ' ' Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5", "Sheet6")).Select Sheets("Sheet6").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\WORK\Template.pdf" _ , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Publish as Wed Page | Setting up and Configuration of Excel | |||
Need Help: Strange, Strange Behavior ( Not Me. My Model! ) | Excel Programming | |||
publish | Excel Discussion (Misc queries) | |||
publish to web | New Users to Excel | |||
Publish Macro | Excel Programming |