<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Export Excel to PDF

0 Points
123 Views
Last Modified:
Learn
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
Author:Learn
  • 6
6 Comments
LVL 3

Author Comment

by:Learn
Dear McKnife,

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

Author Comment

by:Learn
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:Learn
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

LVL 3

Author Comment

by:Learn
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:Learn
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:Learn
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

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Join & Write a Comment

This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month