Q: How do know how to combine all Excel sheets or selected Excel sheets into one PDF file?
A: Please open your Excel document in MS Excel application, press "CTRL" key in MS Excel software and select several Sheets (Sheet1, Sheet2, Sheet3,...), after then, please select "print menu" from file menu, print to PDF Printer, then you can combine Several Sheets into one PDF file properly.

Q: We are in need of a control that would allow us to take data from multiple Word and Excel files and generate a single PDF output file. (Our system is written in Visual Basic 6.0.) This process must run for users without any special privileges. Can one of your products offer this functionality?
A: Our PDFcamp Printer can append several documents into one PDF file, please by following steps to try,
1. Please print one of your Excel document (or other document) to C:\output.pdf file,
2. Please print your second Excel document (or other document) to C:\output.pdf file again, PDFcamp Printer will popup a message box, you can select the "Append to the last page" option to append the second document to the "C:\output.pdf" file,
3. Please by step #2 to print and append all of your documents to PDF file,
4. OK, you will get a PDF file which contain all of your documents.

Q: When I click an Excel document in Windows Explorer, MS Excel application can't open this Excel file automatically, what should I to do?
A: Please unselect "Ignore Other Applications" option from MS Excel, you will get it work work fine.
You may select following options in MS Excel application,
Tools / Options / General / Uncheck 'Ignore Other Applications'

Q: How to set the same Page Setup options for all individual Excel sheets?
A: Please by following steps to set same Page Setup options for all individual Excel sheets.
1. Open the Excel workbook.
2. Right-click the tab for any of the sheets you have in your workspace (by default they sheet tabs are named Sheet1, Sheet2, ...).
3. Choose the Select all Sheets option (which will select all the sheets in your workspace, you can tell they're selected if all the sheet tabs have a white background like an active sheet tab would have).
4. Go to File->Page Setup, select the options you want for the resulting printed pages (it's important that the Print Quality is the same for all pages) and press OK so that Excel will record the fact that all pages have the same print settings. It's important to press the OK button even if you don't change anything, because this will "tell" Excel that all the sheets have the same page setup options.
5. Go to File->Print Preview and see if you like the way the pages will show when printed to PDF. If you don't have any changes to the printing options go to File->Print, select the Entire Workbook option under Print What and PDFcamp Printer from the Printer name section and click OK to create the PDF file
6. PDFcamp Printer will ask you where to save the PDF and (if set so) it will open the PDF when it's created.

Click here to learn more...