Save One Sheet Excel As Pdf

The following sample macro named save excel as pdf 1 is probably one of the simplest way to save an excel worksheet as pdf using vba.

Save one sheet excel as pdf. You can do as follows. Therefore you might find yourself in a situation where you need to save a spreadsheet as a one page pdf in excel 2013. The above steps can only save one worksheet as a pdf file or save the whole excel file as a pdf file. Thus all the worksheet will be in the same pdf file.

Save active sheet as pdf. Unfortunately the pdf version of an excel worksheet suffers from the same issues that a printed worksheet does and you may wind up with a pdf file that contains several unnecessary pages. Activesheet exportasfixedformat type xltypepdf this statement can be separated in the following 3 items. Each excel sheet will be saved as an individual page in your pdf.

There are many scenarios when you may want to save an excel document as a pdf file instead of a spreadsheet. From a vba perspective it is the exportasfilxedformat method combined with the type property set to xltypepdf that creates a pdf. The new convert excel to pdf feature is a nice way to share an excel sheet or multiple sheets without giving someone access to the entire file. Saving excel workbooks sheets charts and ranges as pdf.

In the file type dropdown select pdf. This section contains the base code to save excel as pdf from different objects workbooks worksheets ranges and charts. In the popping up browse for folder dialog box select a folder for saving these pdf files and finally click the ok button. The move or copy utility of excel feature helps you to easily save a certain worksheet as a new excel file.

And then choose the option select all sheets in the menu. For example if you wish to send out only a specific portion of a larger sheet or you don t want it to be editable. Now you have multiple excel sheets saved to one pdf file. Excel files as pdfs.

Right click one sheet tab. Right click on the sheet tab the worksheet you need to save as new file in the sheet tab bar then click move or copy. This macro consists of a single simple statement. Save just one worksheet as new excel file with move or copy.