The code to automatically send e-mail does not work with Microsoft Outlook Express or with Microsoft Windows Mail. If you already have Acrobat Reader installed, you can set the OpenAfterPublish argument in the following code examples to True to open the PDF file after you create it. The following prerequisites and limitations apply when you use this feature: This lets you create the PDF file from a sheet other than the active sheet.Įvery worksheet with an address in cell A1.Įvery worksheet with a sheet-level name (For more information, download the sample file.) Note that you can use the Sheets(“Sheet3”) command instead of the ActiveSheet command to specify a single worksheet. The active worksheet or a group of worksheets. You can create a PDF file from the following: There are several options available when you create PDF files from Excel. You can also use the code demonstrated in this column. To do this, click the Microsoft Office button, click Save As and then select PDF from the Save as type drop-down list. Download the Save as PDF add-in for the 2007 Microsoft Office system.Īfter you install the feature or the add-in, you can manually save or send a PDF file from the Microsoft Office button Save As option.
The add-in also enables you to send files as e-mail attachments in the PDF format in a subset of these applications. If you do not want to install the 2007 Microsoft Office system Service Pack 2, you can install the Save as PDF add-in that enables you to export and save files to the PDF format that is used in most 2007 Microsoft Office system applications. If you have not already done this, you can install the 2007 Microsoft Office system Service Pack 2.
0 kommentar(er)
