+ Reply to Thread
Results 1 to 3 of 3

export various print area's to PDF

  1. 08-29-2017, 07:03 AM #1
    thara95
    thara95 is offline
    Registered User
    Join Date
    02-27-2017
    Location
    kent
    MS-Off Ver
    2007
    Posts
    41

    export various print area's to PDF

    Hi,

    I am trying to export various print area's to 1 pdf file,

    I have the following code but it prints the whole workbook

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-29-2017, 08:58 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: export various print area's to PDF

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 08-29-2017, 09:08 AM #3
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: export various print area's to PDF

    You can also pdf specific ranges, or selections.
    Please Login or Register  to view this content.
    When you use your Macro Recorder and saveas PDF, when you are in the saveas dialog window, select options to see the different pdf options.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  2. How to set fixed print area in excel so cells within print area can still be modified?
    By VictoriaT8 in forum Excel General
    Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  3. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  4. Passing specified Print Area to the PDF Export process
    By Orson100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2009, 08:31 PM
  5. Print Area:Can a print area automatically be defined strictly by the color of the cel
    By slovenc0417 in forum Excel General
    Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  6. How do you turn off a print area for a page? (no print area)
    By Grunen in forum Excel General
    Replies: 4
    Last Post: 10-08-2005, 03:05 PM
  7. Print Area:What would be the code for setting the print area
    By wammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2005, 02:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1