Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
VBA Code (Arrays) to Print PDF's from Excel
Hi VBA developers,
I have an excel spreadsheet with 100 rows. Each row contains details such as Company Reference Number, Company Name, and Revenues for Year 2008, 2009 and 2010 (these are the main headers).
I need to create a Template in Excel (possibly on a second worksheet) displaying this information and link the data to the template so it will loop containing the data of every row. In other words I will have to print the template x 100 (i.e. nr of rows). Ideally I would like to print this as a PDF file (Is this possible by adding VBA coding?).
I believe this will be done by setting arrays and some looping stucture.
If anyone is available to help me please let me know.