The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
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