Method 2: Use Convert Script Method 3: Convert Multiple Excel Worksheets Together For Methods 1 & 2, if you want to convert the whole workbook to PDF, you can just click on 'Advanced' under the 'Save' function and change the default workbook and folder where all the files are saved, then choose whether you want to process the entire workbook, individual worksheets or just the worksheets that you want to convert, and click OK. For Method 3, if you want to process the entire workbook individually, you can choose whether you want to convert the worksheets to separate or merged PDF files. If you have more than one workbook with the same name, you need to find the workbook with the highest number of worksheets or the workbook with at least one worksheet with the same name and rename it if you want it to be converted to PDF file. So, if you want to convert 100 workbooks, you just copy the '100' workbook and rename it to “100.doc”, and then you rename the other workbooks to “101”, “102” and so on, to make them all to be converted to the same file name (101.doc, 102.doc, etc.). Here's the tutorial on how to batch convert multiple worksheets into multiple Adobe Reader files: Learn Advanced Tutorial On How to Batch Convert Multiple Worksheets into Multiple PDF files here.
Hi how to convert an excel file with multiple sheets to PDF so each sheet will be a separate page in the PDF I need use batch document Converter Pro installed the link is in the description of this video I do is drag and drop the file in you can set the output folder so file menu conversion folder setup and this guy is going to set to test nine here okay and click convert this doesn't print to PDF this actually converts the excel file to PDF so now I fell open the PDF here you can see this three pages there because there were three sheets in the original excel file to open the excel file and see that there's three sheets there and that is what's been converted in to the PDF file now with this you can do a hot folder martyring as well CQ now so I have like many thousands of Excel files in the list or you can just more etre going to get options menu dr. Mottershead took activate monitoring I go to monitor this folder here and it's going to convert Excel files just dot Excel yes I'm going to set it to the conversion Apple folder so it's in this door folder here click out to watch a list save and exit now to need to clear the log because it's convertibles before so I'm going to let that run you know you see it's picked it up it's converting it and it should the output should appear in this done folder which it has so now say if I got a new file coming in i screen in that file so you can simulate that so it's now picked up that new file there and it's in the...