<

Export Excel to PDF

1,081 Points
81 Views
Last Modified:
LET (Learn Excel in Tamil)
Hi All,

I joined to this community for share my excel skills and knowledge on open forum,
Thanks
Learnexcelintamil@gmail.com
Export Excel to PDF (All work book and Sheet by single click)
Note: without affecting native/Original File

This Macro Tested and Running successfully  in  Windows7, Windows8 & Windows10 & Excel 2007,10 &13

Dear All,


Excel to PDF.xlsm


This Macro Tested and Running successfully  in  Windows7, Windows8 & Windows10 & Excel 2007,10 &13


This Article is about to Export the excel data's in to the PDF format,


This Macro will run when you click run button provided on the attached macro file, users just need to chose the folders  where excel files are saved to convert.


When you select the folder, this Macro coding will open each files on the selected folder and format the print layout to read it in single page for the columns on the spreed sheet,


if multiple sheets on workbook, this coding will run on all the sheet and export to PDF format.


Once PDF converted successfully, Excel view will be modified from Page layout view to Normal view and close the file with out any changes


So your Raw data will not affected while converting, below are the steps with snap shot 


 1. Once you open the Macro file, please click on Excel to word image to run the macro



2. Enter the file path where you have the excel files



3. Wait for few mints, until you received message box




Please use this Macro and provide your feedback to us


This is my first Article, please provide your feedback or suggestion, please apologizes if not in the correct way


Hint: This Macro will run if Export option enabled on your Excel sheets, 

if not please follow the following link to add the addon's on your excel : https://www.microsoft.com/en-us/download/details.aspx?id=7




Output Screen shot sample:-




Thanks and Regards,

Learn Excel in Tamil


Happy learning!


0
Comment
  • 6
6 Comments
 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Dear McKnife,

More details added on the Article now, please check and advise
0
 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Hi McKnife,

Could you please try to run Macro and let me know, and i am not too familiar  with win8.x and win10, etc,

I know VBA and Excel which ever i know i am posting here and helping for question raised by the users.,

Thanks!
0
 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Dear McKnife,

I will do it, i have tested on windows 7 & 8 , but not on 10 since i don't have system with windows 10 installation, i will add windows 10 and try to run this and post my feedback on  Articles later

Thanks!
Learn Excel in Tamil
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Dear McKnife,

I have tested this Macro in  Windows 7, Windows 8 & Windows 10 & Excel 2007,10 &13 and Running successfully without any errors,

Thanks for your timing and advise

Regards,
Learn Excel in tamil
0
 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Dear McKnife,

Added snap shot for your reference, i don't find any difference i just added sample screen shot with small datas,

i tested with 10 Excel with multiple sheets on single excel.

Thanks and please let me know for any further clarification !

Learn Excel in Tamil
0
 
LVL 3

Author Comment

by:LET (Learn Excel in Tamil)
Dear Mc Knife,

I understood, off course the output will be difference from my macro output, because when I right click and print sheets it will convert as PDF with out any formatting just print and the output will not proper if excel sheet not fit in one page , but my script is not just print or export as PDF, it will  do page layout First and then I will convert as PDF, to make it readable format

If you check my article and script , it's very clear that it will export as PDF with in the excel/Microsoft and hence I don't understand why I need to check with some internal application , my script is not run with any other internal or external printer application, you can review my coding, it's not protected,
And you could have different opinions or you know better coding for this as I know that there will be multiple way of coding, this is my way of coding to simply some operations work to save the timing of there process ,
Instead of open each file, set layout and print this will be quick task for them.

Hope this is clear
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Join & Write a Comment

Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a query in Access that has a calculated column with the results of an Excel worksheet function. See how to call a wrapper function from a query, and …
Discover the basics of using Outlook 2016 from office 365.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month