Vba Save As Pdf















pdf file The three things I need in the code are this: The entire excel workbook needs to be saved as a pdf file. How to convert TIFF to PDF. The MkDir function is used to create a new folder to save the PDF into. I'd also like to be able to manipulate the file name when I save. Excel saves the workbook in the PDF or XPS file format that you selected in Step 4, and automatically opens the file in Adobe Reader or XPS Reader (unless you deselected the Open File After Publishing check box in the Save As dialog box). In this VBA excel automation we are opening a excel workbook by using a dialog box. Around 10 days ago, a blog reader (Sangeetha) asked me if is possible to convert HTML files (web pages) to PDF files using VBA. Macro to save pictures from Word 2010 Workshop. docx" End Sub Related examples in the same category. I end up with files such as main file, temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8 and temp9. Save As PDF macro. Add bookmarks to pdf file using Excel VBA in2thecode. Now go to the Save As menu for saving your report. How to save a Microsoft Word doc as a PDF. I've written about VBA and Acrobat JavaScript before, and I've also mentioned that you can combine VBA and JavaScript to access PDF form fields, but I still owe a sample for that. Convert from HTML to PDF in CSharp VB and ASP. This sample shows how to use the Word Object Model to save as PDF. PasteAsFile: Directly Save Clipboard Items To Files. Name command in the file name it works, however when I change it to a range for a. I have scheduled 8 macros to run a single report and save it to the hard drive as a pdf. Setting up a variable to hold text is quite straightforward. Thanks for your code to save VB form in JPG fomat or a image. Try this: Dim strFilename As String Dim rngRange As Range Considering Sheet1 to be where you need to pick file name Set rngRange. – so VBA knows the file is already open or not / if not open I continue to open the file as indicated in the hyperlink above – if pdf is already open/ the pdf file has to pop up – the pdf file has to open on the correct page as sent to the function many thanks on forehand Danny Focquaert. How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. Export "C:\My Charts\SpecialChart. '----- ' Preconditions: ' 1. Free Charts and Graphs Templates Browse chart templates and examples you can make with SmartDraw. I'm not exactly. How to Convert Excel to PDF (non VBA) Excel export Excel to PDF (non-VBA) In Excel, you can easily export Excel to PDF by navigating to File > Save As, in the Save As Type, you can save a file as different file types. Although the option to save pictures from Word is now possible by right-clicking on them, this functionality is not ported to VBA or. The script to download an SSRS report as a PDF and save it to disk is below. Our algorithm can 'see' tables and understands the spacing between items to identify the rows and columns, much as your eye does when you scan a page. If you always want to save in a certain format you can replace this part of the macro:. If you need to Export Each sheet to an individual. The following code will save the current document as PDF in the same path. I have a PDF file and I need to split this into individual pages I would normally do this manually but I have thousands per month and so I want to automate this process. Open an email, with selected recipients, and attach the current pdf to and email If you have any suggestions to develop the code or see any possible errors please let me know. Excel VBA Models Set 3 XL-VBA3. Worksheet Fill Date And Day And Weeknum Excel VBA By mcrvision at November 17, 2017. / VBA to Create PDF from Excel Worksheet Then Email It With Outlook. Name command in the file name it works, however when I change it to a range for a. I'm really new at vba coding. I've been looking into getting VBA to plot an idw to pdf automatically. In the previous post, I demonstrated how to export Excel to PDF, which is very easy because there is already a built in function to do that (using Save As and choose PDF). docx" End Sub Related examples in the same category. Save does not allow you to save to another file or format while Save As does. For 2007 and up: In excel 2007 there is a built-in option: File / Save & Send / Create PDF & XPS Document. everyday I'am learning something from the website but couldn't save the PDF. 0 - Excel VBA Models Source Code - Numerical Methods and Option Pricing Set - Top4Download. Save as pdf vba excel Use Excel VBA to save a worksheet in pdf format. I don’t want to print, so why does Word insist on talking to my printer?. this assumes that you want to save it in the same folder as the avtive workbook, and indeed that the activeworkbook has been saved. Despite the fact that PDFFilePath is correct, the output PDF is saved beside the original DOC, but always named False. You need to invoke convert to pdf from within Excel, provided you have the plug-ins to do that. By using the Universal Document Converter you will be able to get standard PDF files out of Visio thus making them viewable on any PC. In Excel 2010 and later, you can export a sheet, or a group of sheets, as a PDF file. Vba Code To Save Userform As Pdf File - Hi Everybody I am using excel 2010 - Free Excel Help. I've been looking into getting VBA to plot an idw to pdf automatically. Use this easy to use Invoice Generator template to quickly create and save invoice PDFs in a folder. save userform as gif Get PDF 1288K Save to My Profile E-mail Link to this Chapter Export. So, for instance, if you are working on a document called "MyDoc. Complete with robust error-checking. Save As PDF in Microsoft Excel. If I manually save this worksheet as a PDF, using Excel-->File--Save as Adobe PDF, it saves without issue and the resulting PDF can be opened in Acrobat without issue. necessary to add a Document Open Password to the pdf to open the pdf-file? thank you in advance and. Check out my post on how to write files in VBA. I have downloaded the "Save as PDF / XPS" add-on for Office 2007, so can manually save a report as PDF from Access now. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. If you were hoping to export sheets from multiple workbooks saved somewhere in your network, then check out this tutorial on looping through the files of a folder using VBA. Then Excel will save your workbooks as multipage pdf file. This method suits to those users the most that required, saving Outlook messages in PDF occasionally. but i use the ctrl+alt+del key, the keyboard unlocked. Vba Code To Save Userform As Pdf File - Hi Everybody I am using excel 2010 - Free Excel Help. Open the Immediate window. The 2007 Microsoft Office Add-in: Save as PDF or XPS allows you to export and save to the PDF and XPS formats in eight 2007 Microsoft Office programs. I have scheduled 8 macros to run a single report and save it to the hard drive as a pdf. For a list of valid choices, see the XlFileFormat enumeration. that I got a single PDF file with both sheets. Due to the importance of knowing how to save workbooks using VBA, this Excel tutorial focuses on this particular topic: How to save an Excel workbook using VBA. Below is a simple VBA macro that will allow you to quickly turn your selected worksheet(s) into a PDF file in a snap. I've been able to acheive this in Access like this: [code]DoC. ly/UltExcelVBA Contr. After your VBA macro / code has performed all the required actions, you would want the macro to either save the file or skip saving it. VBA Toolbelt; How Do I Save Multiple Sheets as a Single PDF How do I save multiple sheets (in the same workbook) to a single output PDF? Sometimes you need to deliver NON-Excel reports to your team, and when that's the case PDF is probably your go to. Only these offer standard Windows dialog boxes. Saving to shared network drives. I can use a Mac extension to save as PDF from the print dialog, but the native export in Word always fails. Excel 2007 : Office Button Save As. Saving your work when you complete it is mandatory if you want Word to retain your progress. Currently I have to manually open the pdf file and save-as to an html. This Excel VBA tutorial explains how to export Excel to Word. my requirement is,. pdf file The three things I need in the code are this: The entire excel workbook needs to be saved as a pdf file. com offers free software downloads for Windows, Mac, iOS and Android computers and mobile devices. Print Drawing and Save as PDF Example (VBA) This example shows how to print a drawing document to your default printer and save it as a PDF file. Export "C:\My Charts\SpecialChart. This method suits to those users the most that required, saving Outlook messages in PDF occasionally. Class: Word in Category Microsoft Word : Automation from Total Visual SourceBook Use Microsoft Word Automation to create, edit, save, and output Microsoft Word documents from VBA and VB6. In the code pane below, I've provided three simple VBA procedures that you can assign to a keyboard shortcut that will enable you to quickly and accurately enter the current date, current time, or both as fixed text at the insertion point. Hitch is right. Most just take what they want and run. 7 Click the Save button. The Save as PDF utility can be downloaded from here. › [Solved] VBA codes to merge mutiple into 1 worksheets › Macro to save a file in excel and pdf › Macro to Save File as PDF based on Cell Conte › Macro or VBA code to determine a rang › [Solved] Macro Code, save as PDF › VBA Code to check if a reminder already exists › [Solved] VBA code to insert new row and copy from row above. In the menu bar, click on the option "File" and select "Print. Instantly Fill PDF Forms with Excel Data - Small or Huge Forms! Dynamically Manipulate PDF Buttons, Drop-downs, Checkboxes, Option buttons AND so much more. For an existing file, the default format is the last file format specified; for a new file, the default is the format of the version of Excel being used. If you just installed MessageSave and the messages are saved in MSG format, rather than PDF, please follow these steps. The user that I am referring to is not the BusinessObjects Enterprise user account but the Windows user account. Another way of converting Microsoft Excel File or Spreadsheet in to PDF format is to use "Save As PDF" feature, as available in Microsoft Excel. I'm not exactly. For 2007 and up: In excel 2007 there is a built-in option: File / Save & Send / Create PDF & XPS Document. docx" End Sub Related examples in the same category. Below is the available types in Excel 2013. " No dialog box is displayed; the PDF file is simply created and saved. Many a times we generate certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. pdf file The three things I need in the code are this: The entire excel workbook needs to be saved as a pdf file. PDF VBA automatically converts all kinds of Excel objects to PDFs - objects other PDF add-ins only DREAM of doing. At page 1, the user can fill in his/her personal information. Then selected workbook is saved as a pdf file by this VBA code. In this tutorial, I’ll show you how to use Excel VBA to convert all kinds of Excel objects to PDFs: I’m going to present each of the macros with some commentary. Use Excel VBA to save a worksheet in pdf format. Download excel *. by Avantix Learning Team | Updated January 27, 2019. When I recorded this as a macro, Excel used ActiveSheet when it successfully published the PDF. pdf files to. excel vba save sheet as pdf and email Send emails from Excel with PDF attachment. I am an expert in excel vba but this has baffled me as i cant seem to find any activex dll's which have this functionality?. Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. The option [File] Save and Send | Create PDF/XPS document will (by default) publish the current worksheet. This tutorial shows sample code for doing this. It just saves a copy of the workbook in PDF format. ExportAsFiexedFormat Type:=xlTypePDF End Sub. A user is required to save the Outlook. Excel VBA: Automate Save As File using Internet Explorer Recently I was looking at an Excel forum post and from there I took it on myself as a task to learn and resolve their problem of automating the saving of a file using Internet Explorer. VBA: Loop through all files in a directory and convert them to PDF-files - ConvertWordsToPdfs. Next, paste the following codes instead: 'Directly save Word file as Pdf and aumatically open it. Open install_dir\samples\tutorial\api\2012-sm. I got 0 knowledge on VBA code. Excel VBA export Excel to Word. But in addition to the printers, you’ll find a Save as PDF option. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. necessary to add a Document Open Password to the pdf to open the pdf-file? thank you in advance and. rtf exists in “D:\Users\xxx_xxxxx\Desktop”. How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. The name must begin with a letter and contain no spaces (e. Hey, Scripting Guy! I'd like to be able to open an Excel spreadsheet, get all the information off one of the worksheets, and then save that worksheet data to a comma-separated values file. Excel VBA Introduction Part 41 - Saving as a PDF //www. You can use those exact same methods to identify workbooks when using Save As. Using the PDFTables API, you can use VBA to convert PDF to Excel. I just created a short spreadsheet in Excel (MS 2007), then converted it to pdf in Acrobat 9 Pro and the links work fine after the conversion to pdf. Pertaining to the subject above, i had searched through. The VBA Save As command saves an Excel file as a new file, similar to clicking the Save As icon or using the Save As Shortcut (Alt > F > A). Browse: Home / Excel VBA macro to print your file to PDF. But I need to take it one step futher. All of the VBA works as intended if you execute from the Console. Open the Immediate window. The 2007 Microsoft Office Add-in: Save as PDF or XPS allows you to export and save to the PDF and XPS formats in eight 2007 Microsoft Office programs. com offers free software downloads for Windows, Mac, iOS and Android computers and mobile devices. VBA-Excel: Create and Save the Word document. Save As Save As Saves the file in the default format, but with a different name. Those wishing to use this script may add the code to their callback or execute a shell command from that callback to run the script. On this page: How to save Visio as PDF? Save several drawings to a single PDF. Export "C:\My Charts\SpecialChart. Through the years working as VBA Developer, below is the list of my expertise:. I found a forum where someone posted some visual basic code that would save the worksheets as their own files, with the worksheet names as their filenames, and save them in the same directory the original file is in – perfect. Excel 2007 : Office Button Save As. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a variety of other topics as well. I've pinched below code from the Outlook-Tips and modified it to the required path and now I'm trying to tell it to use the Subject &. Created by Microsoft, this programming language has various uses and applications, as the name suggests. Ausserdem wird da nichts mit PDF erklärt. In the Save As Adobe PDF dialog box, select a PDF settings file, and choose whether to open the file in Acrobat. But for those who prefer to save files locally, here's how to change the default save location in Word, Excel, and PowerPoint. The file format to use when you save the file. Excel 2013: Save a Worksheet or Even Just a Range of Cells as a PDF Document Excel has a really awesome feature that allows you to save your workbook to a PDF document. The code below provides the VBA options to do achieve this. This will invoke the SAPLPD program and prompt for a file name for saving the file. Anyone every attempt something like this?. One-time PDF Format setup. Learn the Top 2 Methods of Manipulating PDFs; Save Up To $439. Below is the available types in Excel 2013. I've been looking into getting VBA to plot an idw to pdf automatically. Open the Immediate window. xlsx) files to pdf files. pdf in a defined network drive, and for the name of the file to be a combination of the text in cells A1 A2 and A3?. xlsx) files to pdf files. All you have to do is: Open the report. 2 of the ISO standard OpenDocument Format (ODF). In this VBA excel automation we are opening a excel workbook by using a dialog box. excel save worksheet as pdf and email Now you know, how to save an Excel Sheet as a pdf. This sample shows how to use the Word Object Model to save as PDF. VBA has an Environ function. but i use the ctrl+alt+del key, the keyboard unlocked. I've been using excel to save my Worksheet as both PDF and as a. Print a PDF using VBA. It seems to work best on documents which were: Converted directly to PDF from Excel; Converted using Acrobat (rather than a clone). Creating PDF Files with Excel VBA. PDF / File > Print > Adobe PDF) Choose target folder & save. 2 includes a powerful formula language as well as a sophisticated metadata model based on the W3C standards RDF and OWL. Problem I am having is that it saves basically a screen-shot instead of just the sheet, so my background comes through along with the sheet. pdf file this Macro will do it for you. But sometimes, you might need to save a workbook in another file format, like the file format of an earlier version of Excel, a text file, or a PDF or XPS file. I'm not exactly. Some of the arguments for this method correspond to the options in the Save As dialog box (File tab). The save file dialog will in fact not save any files! It will just allow the user to select a filename for the file. MeadInKent on You Tube. This functionality is even better if the user is given the opportunity to specify a path and file name. I am trying to have a Macro save an Excel 2007 spreadsheet as a PDF (I have the Save as PDF or XPS installed. Excel VBA - Save As PDF Files. The 2007 Microsoft Office Add-in: Save as PDF or XPS allows you to export and save to the PDF and XPS formats in eight 2007 Microsoft Office programs. best regards gauss Sub xls_to_pdf() Dim member As Variant pdfZähler = 0. 5) I go back into my Excel file and run a macro that attaches the combined PDF file to an email. it shows the properties of icon or file. rtf" (the file used to record. Open the worksheet you will save as PDF and send, then press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window. The user that I am referring to is not the BusinessObjects Enterprise user account but the Windows user account. I'm wondering if it is possible to save the userform as it is, either when click on "Command Button1" save as or automatically with number of the "Ref" field. Creating a Macro to Save a Report as PDF in Access 2010 by The Office User on Jun. SaveAs "C:\MemoTest. Click Export in the blue vertical menu that runs along the left side of your screen. I have posted this thread in the microsoft software forum as well but with no luck. For a list of valid choices, see the XlFileFormat enumeration. My initial reaction was yes, why not? But when I started writing the VBA code I couldn’t imagine that it will take me so much time to finish this project. As you work with Visual Basic for Applications, you'll notice that saving workbooks is one of the most important things your macros can do. I'm not exactly. How to Convert Excel to PDF (non VBA) Excel export Excel to PDF (non-VBA) In Excel, you can easily export Excel to PDF by navigating to File > Save As, in the Save As Type, you can save a file as different file types. Sharing an Excel spreadsheet as a PDF document has its advantages. When I use the ActiveSheet. Microsoft Office Excel 2007 lets you save your workbook files directly in the PDF (Portable Document File) file format developed by Adobe Systems Incorporated. At page 1, the user can fill in his/her personal information. Any help greatly appreciated. Use Excel VBA to save a worksheet in pdf format. How do I convert a text file to an Excel file? Contact Lists Updated on August 6, 2018. Thanks for your code to save VB form in JPG fomat or a image. Add ThisWorkbook. i've a problem in that coding. If you are printing to instead of converting the sheet to a pdf document, then you are losing the links. Give your macro an appropriate name. Macro to save as pdf with ability to choose save as folder I was lucky enough to come across this macro on this forum to save as pdf but I need to alter a bit so that it allows the user to select the folder to save it in. if double click on icon or file name,it doesn't open it. Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. Once they fill it out, they will need to save the form as a non-fillable file (normal PDF?) and send on to others to be read-only. Save an Excel 2007 workbook as a PDF file or as an XPS file. Close a workbook using VBA in Microsoft Excel. so I’m trying to SAVE the document as a PDF using the inbuilt Save As option, and Word (2013) insists on querying my default printer (in an office miles away, leading to a long hang when I can do nothing in Word). Most of the time, you'll probably want to save your workbooks in the current file format (. This creates the folder in the path specified in the macro. Below is a simple VBA macro that will allow you to quickly turn your Microsoft Word Document into a PDF file in a snap. Sub Save_PDF_1() ActiveSheet. You will see an "Options…" button appear. I just want to set the file name from VBA and have no user interaction when the PDF is created. This method suits to those users the most that required, saving Outlook messages in PDF occasionally. Our algorithm can 'see' tables and understands the spacing between items to identify the rows and columns, much as your eye does when you scan a page. This userform also contains images. The same can also be done for a Word document to print it as a PDF. Save Workbook as New File using VBA in Excel How to Avoid Incorrectly Typing the Name of an Existing Variable in VBA Script? Using Message Box (MsgBox) in Excel VBA. Anyone every attempt something like this?. This Macro coding uses Microsoft Word capabilities to save Outlook emails as PDF format. Creating PDF Files with Excel VBA. How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. VBA to save current sheet to PDF in same directory. There are two ways to save Outlook messages in PDF format: by printing to a PDF printer or saving in PDF format from Word. I am trying to save four sheets into a single PDF. In the old toolbars under Menus tab, you can save Microsoft Excel 2007/2010/2013/2016/2019 workbooks as 97-2003 workbooks directly. With lot of versions of MS Office and other Office suites around. So, let's get started! Note. For 10 + years, this firm has specialized mainly in the development of custom IT solutions for business ranging from databases, automated workbooks and documents, websites and web applications. Using script recorder and many useful contents given on this forum, I some how able to complete point 1 & 2. Using the PDFTables API, you can use VBA to convert PDF to Excel. It seems to work best on documents which were: Converted directly to PDF from Excel; Converted using Acrobat (rather than a clone). Method 2: VBA Macro Coding. I am somewhat of a newbie to VBA. Use the Project Explorer to browse to the module where you need to automate saving the spreadsheet as a PDF file. To save an Excel document as a PDF file make use of a virtual printer such as the Universal Document Converter. The following needs to be placed in a regular VBA module. Setting up a variable to hold text is quite straightforward. Creating PDF File from Excel using VBA Script - Adobe Acrobat Windows. Save each worksheet separately to multiple workbooks (#MakeMultipleXLSfromWB) This subroutine is going to take awhile to run so would suggest that you exit out of each module in the VBE and then exit out of the VBE itself; otherwise, even though screen updating is turned off you will be bouncing around in the VBE constantly changing views. Due to the importance of knowing how to save workbooks using VBA, this Excel tutorial focuses on this particular topic: How to save an Excel workbook using VBA. Next it will check if t140102. That's OK, provided they are not selling on the material as their own; however if your productivity gains from the material you have used, a donation from the money you have saved would help to ensure the continued availability of this resource. Chrome also fails to open the PDF. but i use the ctrl+alt+del key, the keyboard unlocked. it works nicely for to save vb forms. However, it uses the old version of PDF Creator, because the new one has totally different methodology, names and calls. DoubleSizeAndMove). You need to invoke convert to pdf from within Excel, provided you have the plug-ins to do that. Generate PDF report and save to specific folder. Currently their entire process would be: Save to PDF (File > Save As >. VBA to save current sheet to PDF in same directory. Hi I am looking for a VBA code that will save an excel file in a specified folder as a PDF based on cell values and then open an email with pre defined email addresses and subject/body based on text/cell values. When I tried the Active Sheet(s) option, I got what I wanted. Also, we have seen how to send the ActiveSheet as an attachment in Email. Introduced originally in Access 2007, this functionality was exposed though the Access GUI (Graphical User Interface), in Access Macros, and in VBA code. How to Convert Excel to PDF (non VBA) Excel export Excel to PDF (non-VBA) In Excel, you can easily export Excel to PDF by navigating to File > Save As, in the Save As Type, you can save a file as different file types. Enter the filename with full path and click ok to save the pdf file in the mentioned path. For 2007 and up: In excel 2007 there is a built-in option: File / Save & Send / Create PDF & XPS Document. How to save a Microsoft Word doc as a PDF. Save selection or entire workbook as PDF with VBA Macro. Notify me of followup comments via e-mail. I'm not exactly. Click the File tab in the top-left corner of your Word screen. Download excel *. (There is a third way: use Adobe Acrobat's package feature. Let's talk Office 2010. I hope that was clear. To save an Excel document as a PDF file make use of a virtual printer such as the Universal Document Converter. If you need to create a copy of a single page from a larger PDF file, you don't need any expensive software. How to save an Access report to pdf with filename based on fieldname. Select multiple worksheets using Excel VBA. Sub Save_PDF_1() ActiveSheet. A VBA procedure to save a word document as a PDF. Save a file as a particular type using a macro. This creates the folder in the path specified in the macro. Then Excel will save your workbooks as multipage pdf file. Start a macro recorder, go to: File / Save as. It makes a really nice PDF archive, if you own Acrobat. I have previously used a macro to call PDF Creator to save an invoice created in excel 365. pdf file this Macro will do it for you. What I would like to do is to program, via VBA, the whole "Create from website" part so that the whole thing is done automatically. save as pdf without acrobat VBA code, PDF saved as different file type, Adobe Professional. OpenOffice. The code I use works perfectly (see below). Downloading the Utility. Using Excel Vba To Open, Save As, And Close Embedded Pdf Files - Excel View Answers I am currently trying to write a macro which will open an embedded pdf file in from excel, open it in acrobat reader, automatically save a copy of it into a predesignated folder, and return to excel to repeat the process. The basic pricipal that you need to remember when saving to a shared network drive is that the user that is running the VBA macro code must have write access to the the shared network drive. How to Convert Excel to PDF (non VBA) Excel export Excel to PDF (non-VBA) In Excel, you can easily export Excel to PDF by navigating to File > Save As, in the Save As Type, you can save a file as different file types. Add bookmarks to pdf file using Excel VBA in2thecode. Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. Hi Patrick - Thanks for the information. Save Report as PDF File To save an Access report as a PDF file basically involves selecting "Acrobat PDFWriter" as your printer, then selecting the name and path for your PDF file. after usaing that coding my keyboard locked. For example, you might create a new document to use as a scratch pad or to test out a new feature. I can create a pdf of my Visio diagram by selecting Print and selecting pdf, but when I attempt to "Save As" a pdf type it renders incorrectly. Save Copy As Saves the active document to a specified file. '----- ' Preconditions: ' 1. Hi there I am working on a Excel (2010) using VBA where I am creating a MS word document and I want to save the document as pdf is it possible? If so how can I do it Thanks for your help and assistance. (There is a third way: use Adobe Acrobat's package feature.