Create pdf from multiple excel sheets vba

How to Use Excel VBA for Printing

I have an excel file in which I have a macro that creates a series of PDF files via the Active Sheet.

Create Pivot Table or Excel Table from

I am attempting to do this with PDFCreator version 1.

Sample <strong>Excel</strong> Spreadsheets - <strong>Excel</strong>

Sample Excel Spreadsheets - Excel

I then go into object browser and can see the diffent objects that are available, but none of them have a description of what they do so I am at a loss at to which commands will help with the task I am attempting. I end up with files such as main file, temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8 and temp9.

VBA Code Excel Macro Examples -

(If anyone knows of a resource that explains the objects I would appreciate it if you point me in that direction. Value = i Do While Range("C1") Sub ken() Dim output PDFName As String Dim output PDFPath As String '/// Change the output file name here!

Create pdf from multiple excel sheets vba:

Rating: 91 / 100

Overall: 91 Rates