The threshold at or above which an image is down-sampled to the ColorDownsampleTarget level. The threshold at or above which an image is down-sampled to the OneBitDownsampleTarget level. The style in which to print the exported file. Can be one of the PbPrintStyle constants. The default value depends on the value of the Intent parameter. Whether to include document structure tags to improve document accessibility. The default is True. Whether to include a bitmap of the text.
Pass True for this parameter when font licenses do not permit a font to be embedded in the PDF file. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 10 months ago.
Active 3 months ago. Viewed 26k times. I use Excel with VBA. I have the following code : mySh. Any ideas? Thanks for your help. Improve this question. Chapo Chapo 2, 3 3 gold badges 21 21 silver badges 48 48 bronze badges. I have had this issue previously but cannot remember if I fixed it or hacked it.
Have you investigated how the zoom affects results? PageSetup property. In this particular situation, the Worksheet object is the active sheet ActiveSheet. The PageSetup. CenterHeader property allows you to set what appears in the center section of the page header.
You specify the text that you want to appear in this section as a string. You can generally apply the syntax and explanation I provide here for the CenterHeader property to the following roughly equivalent properties:. You can use the PageSetup. Orientation property for purposes of setting the xlPageOrientation value that specifies the page orientation.
The Orientation property can take the following 2 values :. You generally specify the relevant range using A1-style references and as a string. Under the A1-style cell referencing style, you use letters for column headings and numbers for rows. This range is from cells B5 to F PrintTitleRows property allows you to specify that a particular row or set of rows should be repeated at the top of each page. Generally, you specify the rows to be repeated as a string using A1-style references.
In this particular example, I don't explicitly type A1-style references in the code. Rows 5. You can generally use the same principles and syntax that I explain here in connection with the roughly equivalent PageSetup.
PrintTitleColumns property. By using the PageSetup. Zoom property, you can determine how Excel scales the relevant Excel worksheet for printing or, in this case, conversion to PDF. As a general rule, you specify the zoom as a Variant value between 10 and percent. Whenever PageSetup.
Zoom is set to False, the properties that determine how Excel scales the Excel worksheet are PageSetup. At the same time, if the PageSetup. FitToPagesTall property for purposes of setting the number of pages tall to which the relevant Excel worksheet is scaled to when printing or, in the case of the example in this tutorial, converted to PDF.
This is done in…. The syntax and purpose of the PageSetup. In other words, you use the FitToPagesWide property to specify the number of pages wide the relevant Excel worksheet is scaled to when printing or converting to PDF as in this example.
As anticipated above, this End With statement simply ends the With… End With block that we've just analyzed. As I show in this example, you can make several changes or adjustments that influence the resulting PDF file by using the PageSetup object.
You can use this parameter to set the filename of the resulting PDF file. Visual Basic for Applications allows you to do either of the following :. The use of the Filename that I make in these first 3 examples may work for you in certain circumstances. After all, the material structure of those macros is enough to help you save Excel worksheets, workbooks, ranges or charts as PDF files.
However, in several situations, you'll want to use the Filename parameter in a slightly different way for purposes of creating more sophisticated macros that save Excel files as PDF. Let's take a look at some different ways you can use the Filename parameter:. If you're creating a macro to save Excel files as PDF, and those PDF files must always be saved in the same folder, you can simply hard-code the relevant file path and name using the Filename parameter of ExportAsFixedFormat.
Notice, however, how I've specified the full path of the file using the Filename argument. The consequence of this change is that the resulting PDF file is no longer saved in the default folder. Instead, the PDF is saved in the folder that you specify with the Filename argument. In the example above, the file is saved to a OneDrive folder called Power Spreadsheets.
You don't necessarily need to hard-code all of the details in the Filename parameter. You can, for example, concatenate different items for purposes of building a more flexible filename structure. In other words, if you use this Filename structure, the new PDF file is saved in the same folder as the source Excel workbook. The reason for this is that the Workbook.
Path property returns a string with the complete path to the relevant workbook. In the case of the example above, the relevant workbook is the active Excel workbook returned by the Application. ActiveWorkbook property. Name property using the Application. ActiveSheet property to return the name of the active worksheet as the actual filename within the Filename parameter. The file path continues to be provided by the Workbook. Path property. In this particular case, the macro uses i the Application.
ActiveSheet and Worksheet. Range properties to return cell F5, and ii the Range. Value property to return the value in that cell. You can achieve similar results using slightly different structures. This includes, for example, naming the converted PDF file by concatenating several strings of text. In some cases such as when concatenating several strings of text to specify the PDF filename , it may be more appropriate to declare a variable at the beginning of the procedure to store the applicable string.
Whenever you use a worksheet cell as the source for the PDF filename as in the example above , make sure that the cell contains no forbidden characters. The VBA code samples that I provide in this section are just some of the examples of the different ways you can work with and generate the Filename argument of the ExportAsFixedFormat method.
As you can see, Visual Basic for Applications provides significant flexibility in this regard.
0コメント