Results 1 to 3 of 3

Save Excel Charts to PDF in Landscape Orientation and Fit Page

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    47

    Save Excel Charts to PDF in Landscape Orientation and Fit Page

    I have a workbook with four worksheets (Sheet1, Sheet2, Sheet3, Sheet4) that contain nothing more than a basic Excel chart in each sheet. I would like to write a macro that when I click the macro button, I will be prompted to name the file and select a save location. I would like to save each excel chart in Landscape orientation, as well as FitToPagesWide = 1 and FitToPagesTall = 1.

    The idea is that the charts will print to independent pages from the .PDF and be large enough I can display them on a board. The paper could print in basic A3, or A4, depending on the country where the printing is going to occur.

    Here's what I have... It works to save the four sheets to .PDF pages, however, they are not in landscape orientation and they do not fill the page to the maximum size the chart can stretch without going off the page:

    Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select
    Dim saveLocation As String
    saveLocation = Application.GetSaveAsFilename( _
    fileFilter:="PDF Files (*.pdf), *.pdf")
    If saveLocation <> "False" Then
    ActiveSheet.ExportAsFixedFormat xlTypePDF, saveLocation, xlQualityStandard
    End If
    Last edited by huntethic; 02-15-2017 at 05:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro To save multiple Excel sheets to multiple (individual) PDF Files
    By Keith Edgar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2014, 12:51 PM
  2. Replies: 2
    Last Post: 09-19-2013, 04:22 AM
  3. Macro to save to PDF and retain 11x17 landscape
    By Dougl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 06:52 PM
  4. Save multiple sheets as web page
    By leighmills33 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2011, 03:33 AM
  5. Replies: 0
    Last Post: 11-08-2007, 09:58 AM
  6. [SOLVED] Print Area. 1st page Landscape 2nd page Portrait??
    By Corey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2006, 03:25 AM
  7. Printing Multiple Sheets -- Printer Forcing Landscape/Portrait
    By Jakeman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1