Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PDF export add-in
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Excel tuncating leading zeros while export to excel from da | Setting up and Configuration of Excel | |||
Chart.Export images are shrinking as I export more images | Charts and Charting in Excel | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
export as csv | Setting up and Configuration of Excel | |||
CSV export help | Excel Discussion (Misc queries) |