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
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.
0 comments:
Post a Comment