Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: VBA excel 2011 save as PDF

  1. #1
    Join Date
    21st February 2012
    Posts
    102

    VBA excel 2011 save as PDF

    Used the following:
    VB:
    Sub SavePDFMacro() 
         
        ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ 
        "Macintosh HD:Users:Mach7:Desktop:" & Range("AA1").Value, Quality:= _ 
        xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ 
        OpenAfterPublish:=True 
    End Sub 
    
    
    The set print area should be saved as a PDF file onto the desktop using as file name the value found in Cell AA1.
    The code is doing just that. No issue here.

    I would like to adjust the paper size and the margin as to maximize the appearance.
    Right now I get a pdf that is either a A4 or a 8.5 by 11.
    Any suggestion to force the pdf to save as legal that is 8.5 by 13 (215.9 by 330.91 mm). Note Excel is already using this size as default, however the created PDF does not.

    Thanks for your suggestions.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    21st February 2012
    Posts
    102

    Re: VBA excel 2011 save as PDF

    posted on VBA Express under Mac's forum.
    link.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 4
    Last Post: March 19th, 2012, 10:03
  2. Progress Indicator Bar possible in Excel for Mac 2011?
    By mischiefwizard in forum EXCEL HELP
    Replies: 2
    Last Post: November 20th, 2011, 08:46
  3. Mac Excel 2011 Add Ins?
    By jimdreher in forum EXCEL HELP
    Replies: 1
    Last Post: November 5th, 2011, 01:29
  4. Replies: 9
    Last Post: August 23rd, 2011, 23:10
  5. Replies: 4
    Last Post: July 7th, 2011, 04:45

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
  •  
porno