Excel VBA to Export Selected Sheets to PDFIm pretty mixed up on this. I am also running Excel 2. I tried saving two sheets as a single PDF using This. Workbook. SheetsArray1,2. Select. election. Export. As. Fixed. Format xl. Type. PDF, File. Name. pdf,, , False. I got nothing but blank pages. It saved both sheets, but nothing on them. It wasnt until I used This. Vba Print Pdf File Without Opening' title='Vba Print Pdf File Without Opening' />Workbook. SheetsArray1,2. Select. Active. Sheet. Export. As. Fixed. Format xl. Install Php Module Apache Ubuntu on this page. Type. PDF, File. Name. False. that I got a single PDF file with both sheets. D Text S'>3D Text S. I tried manually saving these two pages using Selection in the Options dialog to save the two sheets I had selected, but got blank pages. When I tried the Active Sheets option, I got what I wanted. When I recorded this as a macro, Excel used Active. Sheet when it successfully published the PDF. FhXtuk/U2e4pCuX3_I/AAAAAAAACVo/jgMf3_QldO4/s1600/PDF+Search+Through+VBA.jpg' alt='Vba Print Pdf File Without Opening Conditional Formatting' title='Vba Print Pdf File Without Opening Conditional Formatting' />Sub Example2 Final string to print to file Dim strFinal As String Line read from original text file Dim strLine As String Close 1 open the text file for reading. There are many advice of how to reduce the file size of your Excel workbook. Weve tested them and found some surprising results. Check out the full studyFrom the PowerPoint FAQ How do I use VBA code in PowerPoint. Generate a list of all tab names in a workbook without using VBAmacros. Working with Tables in Excel 2013, 20 VBA This article has also been published on Microsoft Office Online Working with Excel tables in Visual Basic for. A Guide to the Administration of Decedents Estates for laypeople. I have a 1,500 page PDF document. I can open the PDF file with the script below from VBA using Access 2007, see the document, and see that I m.