Vba print worksheet to pdf

Range "A1:N24". ExportAsFixedFormat … Reviews: 5. Use the following code in your macro to save your file as PDF. DoEvents Loop Until …. Toggle navigation Websiteperu. Home Extension Country Pricing. Keyword Research: People who searched vba microsoft print to pdf also searched.

Frequently Asked Questions. How do you print in VBA? How do I print into a PDF file? Search titles only. Search Advanced search….

Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser. VBA Print to pdf. Thread starter Qqqqq Start date Aug 25, Qqqqq New Member. Joined Feb 6, Messages I have a macro that prints a single worksheet to a pdf file, which I've used successfully many times. I moved this code into a new workbook, and it doesn't work.

When I get to the ActiveSheet. VBA Code:. GetBaseName xWB. Sheets "Sheet1". Select ActiveSheet. Excel Facts. Viewed k times. There are two things I want to do though: Is there a way that the PDF file can create a folder on the users desktop and save the file with a file name based on specific cells in the sheet? Worksheets "Rental". Range "A1:N24". Worksheets "RentalCalcs". Value Range "C12". Range "O1" 'ThisWorkbook. Sheets Array "Sheet1", "Sheet2", "Sheet3".

Select Worksheets "Rental". Select Selection. Select Worksheets "RentalCalcs". Activate Range "D4:E4". Select End Sub. Improve this question. Teamothy 1, 3 3 gold badges 13 13 silver badges 19 19 bronze badges. Preena Preena 1 1 gold badge 2 2 silver badges 11 11 bronze badges. Add a comment. Active Oldest Votes. Value Debug. Use that. Worksheets "Sheet1". Improve this answer.

Matt Matt Update - I changed the O1 in the range to A1 and it worked - however the name I want to save the file as is in cell O1 — Preena. It is also only now printing one of the Tabs not both. Your If statement is flawed unless you are really comparing to the string false.