Forum Discussion
Export to single PDF file
Hello everyone!
I have in a spreadsheet a cell with a list validation of 5 items, a table with formulas that depend on this cell and a chart representing the table.
I want to have a button that launches a macro in VBA that applies the first value of the list of the validation cell, updates the table and the chart and exports it to a PDF page and so on with all the values of the list, generating at the end a single PDF file containing as many pages as values has the list.
What would be the macro code that would perform this process?
Thank you very much
Attached is a link and a workbook with examples from this link.
You have to adjust them to your liking.
Mail from Excel and make/mail PDF files
I hope that this link will help you with your project.
I know I don't know anything (Socrates)
- Thanks for your answer NikolinoDE but it doesn't solve what I wanted to do. Anyway, I have used an alternative to be able to generate each graphic on a different page of the same PDF file.
Regards
