+ Reply to Thread
Results 1 to 8 of 8

How to Export sheet in pdf In excel 2007

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    How to Export sheet in pdf In excel 2007

    Hi Firends,

    i am trying to export the active sheet in pdf.
    below code works fine in exel 2010 but not in excel 2007.

    Please Login or Register  to view this content.
    Please suggest me how to export sheet in pdf in excel 2007.

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: How to Export sheet in pdf In excel 2007

    Hi,
    Simple way how I used to do this - install PDF Creator (or some simillar PDF printer programm), set this PDF printer as Default, configure this PDF creator to automatically save PDF files in some folder and then just use standart "print" options in your code.

  3. #3
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to Export sheet in pdf In excel 2007

    Hi Kasan,

    thanks for reply.
    i have "Dopdf". is it possible in Dopdf?

    also i have made a macro in excel 2010 and want to run this macro on another PCs.
    some PC have 2007 and some have 2010 excel installed.
    In this case how can i set the macro to run on both the PCs

  4. #4
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: How to Export sheet in pdf In excel 2007

    I dont know that is Dopdf and how it works, if its "print in pdf" application - it should work.
    About different versions its tricky, best solution would be one code that works on both versions, but if not you can check version of excel before your main code and then run one of two code versions, like
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to Export sheet in pdf In excel 2007

    Hi Kasan,

    thanks for the script.

    i have install SaveAsPdf add-inns.
    now it works in 2007 excel.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: How to Export sheet in pdf In excel 2007

    You should be able to use Exportasfixedformat in 2007 as long as you have SP2 or later installed. (and if you don't there are so many bugs it's unbelievable)
    Rory

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: How to Export sheet in pdf In excel 2007

    And this is the link to SaveAsPDFXPS addin
    http://www.mediafire.com/file/pjp8od...dd-In.rar/file
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  8. #8
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to Export sheet in pdf In excel 2007

    thanks YasserKhalil and rorya

+ 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. Excel 2007 VBA to Export Sheet as PDF doesn't work in 2013
    By WilliamJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 07:28 PM
  2. Export As A Fixed Format Excel 2007
    By thehelgeson13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2014, 12:55 PM
  3. Excel 2007 : [XML] import -> filter -> export
    By beeryourself in forum Excel General
    Replies: 9
    Last Post: 10-29-2013, 09:40 AM
  4. Export FROM Excel TO MS Project 2007
    By Drivium in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 03:06 PM
  5. Need to export from excel 2007 table or sheet to a bulleted list in MS Word 2007
    By jc0045 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2011, 11:55 PM
  6. Excel 2007 : Excel 2007 Export to PDF issues
    By sbgstudios in forum Excel General
    Replies: 0
    Last Post: 03-26-2009, 03:52 PM
  7. How to Export to an Excel 2007
    By Amitabh Wankhed in forum Excel General
    Replies: 1
    Last Post: 04-13-2007, 11:37 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