+ Reply to Thread
Results 1 to 4 of 4

How to print pdf from

  1. #1
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    How to print pdf from

    Hello Everyone

    In attached sheet, I want to print the data of all splitted sheet (range is A:N) into PDF format automatically generated from the main sheet "Data" through Macro.

    I am attaching my requirement in attached documents.

    Your help is highly appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-29-2013
    Location
    Pattaya, Thailand
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: How to print pdf from

    I might be mistaken, but you can set print area and titles under page layout. The PDF part I'm unsure about, but if you have a PDF printer available (like adobe PDF converter) then it should save the file to PDF according to your printer settings. Just so you know: the pdf printer isn't a real printer, it emulates being a printer to the system and saves your document as a PDF on your system.

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: How to print pdf from

    Thanks ..
    can you help me to generate PDF automatically with the sheet name from the range of column A:N
    Last edited by sarat47; 11-29-2013 at 04:38 PM.

  4. #4
    Registered User
    Join Date
    11-29-2013
    Location
    Pattaya, Thailand
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: How to print pdf from

    Quote Originally Posted by sarat47 View Post
    Thanks ..
    can you help me to generate PDF automatically with the sheet name from the range of column A:N
    I'm sorry, but the automation part is something I can't help you with. I'm a novice and don't know anything about scripting or coding. If you really get stuck you could always try odesk for some expertise help. A little job like yours would cost you $4 or $5 to get someone to do it for you.

+ 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. Replies: 2
    Last Post: 08-29-2016, 01:36 PM
  2. [SOLVED] Print array code for a series of pages that will also determine print area required?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2012, 11:46 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. Replies: 4
    Last Post: 02-17-2006, 08:36 AM
  5. [SOLVED] Pivot Table macro to set print area and print details of drill down data
    By Steve Haskins in forum Excel General
    Replies: 2
    Last Post: 12-28-2005, 01:10 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