How to convert an Excel sheet into PDF in Office 2007

There are many web  based application available to convert an Excel sheet into PDF document. However, In most of these 
applications only limited features are available for free and are also subjected to daily usage limit. Follow the below steps to convert anExcel sheet into PDF document.

  1) Download and Install Excel to PDF AddIn from Microsoft's official website.
      
  2) Open the Excel Sheet which you have to convert into PDF.
  3) Open Visual Basic Editor from Developers tab and paste the following code into the Module

            
                                       ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
                                       Filename:="C:\Users\EA\Desktop\KPSC\New.pdf", _
                                                    Quality:=xlQualityStandard, _
                                                    OpenAfterPublish:=False

  4) Make sure that file path provided is correct. 
  5) Now run the code to get the activesheet converted into PDF.
Share:

0 comments:

Post a Comment