• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel input to formatted PDF output

Thokam_Patti

New Member
Hi All,

Want to create banners for multi locations across the country, the background and font size in out put would be the same but the text would change according to the location. for each location there would be multiple banners

Since these are to be printed at one place I want to collect PDF files so that I can send back the printed material.
So
1> ill send the xl files
2> user would generate the PDF file by inputting this requirement
3> send back the PDF file to me

Request suggestion on how to get it done, also if the thread also exists
 
My suggestion.

1. Leverage user form to enforce adherence to rules.
2. Use VBA to save as PDF & email to you
 
Back
Top