+ Reply to Thread
Results 1 to 2 of 2

save range to PDF

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    save range to PDF

    Hello all,

    I have this code to save a certain range to PDF.
    It used to work but then I played a bit with print sizes and things like that. (don't really remember what I did , I hardly changed the range size)
    Now it doesn't fill the PDFpage anymore, as it used to do.

    Is there a way to reset all print page settings? Or maybe there is another reason for this...
    (I noticed it is still set on A4 with normal custom margins)

     Worksheets("Off - fact").Range("A1:K47").ExportAsFixedFormat Type:=xlTypePDF, Filename:=DirName & OfferteName, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=maakpdf

  2. #2
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: save range to PDF

    Wish I could rep myself...

    Change the scale back from 51% tot 100% xD

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save File Using a Range Name
    By John Vieren in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-26-2013, 05:52 AM
  2. [SOLVED] Select Range and Save As PDF? On a mac
    By thequiff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2013, 01:50 PM
  3. export a range and save as .jpg
    By skooter2k5 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-04-2010, 09:20 AM
  4. Save range in a new workbook as .gif
    By Pinokkio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2009, 06:02 AM
  5. How can I save a range as its own .csv?
    By cqq1jmg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2005, 11:51 AM

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