ARTS PDF Workshop Version 3.
ARTS PDF Workshop User Guide Contents Contents 1. INTRODUCTION .............................................................................................. 3 2. SETUP .......................................................................................................... 5 2.1. System Requirements ................................................................................ 5 2.2. Installation............................................................................................... 5 2.3.
ARTS PDF Workshop User Guide Introduction 1. Introduction ARTS PDF Workshop is an add-in for Microsoft® Excel that allows users to easily manage their PDF document collection. ARTS PDF Workshop creates an Excel spreadsheet that is populated using file information from these PDFs. The spreadsheet can be updated with any required changes and these changes, once applied will be reflected in the original PDF files.
ARTS PDF Workshop User Guide Introduction Figure 2.
ARTS PDF Workshop User Guide Setup 2. Setup 2.1. System Requirements Windows • • • • • • Intel® Pentium® processor or equivalent Microsoft® Windows 98 SE, ME, Microsoft Windows NT® Workstation 4.
ARTS PDF Workshop User Guide Setup 2.3. Activation If you have the demo version of ARTS PDF Workshop installed, activate the full version using the following steps: 1. Select ‘Run ARTS PDF Workshop’ the Data menu within Excel or click the ‘Run ARTS PDF Workshop’ toolbutton. 2. Select the ‘About’ button. 3. Ensure you have a valid serial. To obtain a valid serial you must purchase the product: a. Select the ‘Register’ tab page and click on ‘Buy Now’ to purchase the full version. b.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3. Using ARTS PDF Workshop 3.1. Getting Started After successfully installing ARTS PDF Workshop, open MS Excel and locate the ARTS PDF Workshop Toolbar (described below). If the toolbar is not present please consult the FAQ section of this user guide. Before being able to apply any updates to your PDF document collection you must first populate a spreadsheet with document information. To do this you must first Run ARTS PDF Workshop (see section 3.13).
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3.3. Remove Logs Removes all ARTS PDF Workshop logs from the current spreadsheet. Figure 4. ‘Remove Logs Instructions on use 1. Select any entry in a valid ARTS PDF Workshop spreadsheet. 2. Press the ‘Remove Logs’ button (Figure 4). Additional information It is important to note that you cannot remove a single ARTS PDF Workshop log. Using this function will remove all logs simultaneously.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop Instructions on use 1. 2. 3. 4. Select two or more PDFs to merge together from the spreadsheet. Click on the ‘Merge Files’ button (Figure 5). Select the destination for the new PDF file. Choose the name for the new PDF file. Additional information This function is limited to use with PDFs containing no security of any kind (passwords and ‘Do Not Allow’ options).
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3. Select the PDFs whose security settings you wish to configure. 4. Press the ‘Apply security’ button (Figure 7). 5. Press the ‘Update Metadata’ to apply the security settings. Changing the security settings of PDFs already containing security: 1.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop Opening a secured PDF file: 1. Enter the open password into the ‘Current User/Master Password’ columns for the corresponding PDFs that you wish to open. 2. Select the relevant PDFs. 3. Press the ‘Open Files’ button (Figure 8). 3.8. Set Initial View on Selected PDFs Configures the way the PDFs appear when they are opened in Acrobat. Figure 9. Set Initial View Instructions on use Configuring Open Info for non-secured PDFs: 1. 2. 3. 4.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3.9. Review Document Info for Selected PDFs Open multiple PDFs in Acrobat, and display their General Info window. Figure 10. Display Metadata Instructions on use Reviewing Document Info for non-secured PDFs: 1. Select the PDFs whose Document Info you wish to review. 2. Click the ‘Display Metadata’ button (Figure 10). Reviewing Document Info for open secured PDFs: 1.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3.11. Refresh Spreadsheet Information Updates the information contained within the spreadsheet, with that contained in the PDFs. Especially useful when PDFs on a spreadsheet have been modified outside of PDF Workshop, or after PDFs security settings have been modified within PDF Workshop. Figure 12. Refresh Worksheet Instructions on use Refreshing PDFs containing no open passwords: 1.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop Additional information If the PDF you attempt to print has ‘Do Not Allow Printing’ selected, then it will not print.
ARTS PDF Workshop User Guide Using ARTS PDF Workshop 3.13. Run ARTS PDF Workshop Creates an ARTS PDF Workshop spreadsheet. The information generated within the spreadsheet, is dependent on the options that the user selects. Figure 14. Run ARTS PDF Workshop Instructions on use 1. Press the ‘Run ARTS PDF Workshop’ button (Figure 14). 2. Click on ‘Browse’ button from the main menu to search and select a folder to run ARTS PDF Workshop on. 3.
ARTS PDF Workshop User Guide Appendix 4. Appendix 4.1. Spreadsheet Options When setting up a ARTS PDF Workshop spreadsheet, there is a range of options that can be selected. Title Subject Author Keywords Page Count Initial View Filename Creator Producer Created Optimized File Size (Bytes) Last Saved Security Settings Column Autofit Screen Updating Hide Location Include Subfolders Save settings on close | CONTENTS | Displays the PDFs Title information. Displays the PDFs Subject information.
ARTS PDF Workshop User Guide Troubleshooting 5. Troubleshooting 5.1. Frequently Asked Questions This section provides some answers to common questions and details on what to do if a problem is encountered concerning the following: Document is already open Missing toolbars General • • • Document is already open “I am getting an Error Message: "A document with the name 'PDFWorkshop.XLA' is already open..." To fix 1. 2. 3. 4. 5.
ARTS PDF Workshop User Guide Troubleshooting 5.2. Forum Are you having a problem that you can’t find in the Frequently Asked Questions? Then perhaps you’ll find it on the ARTS PDF Forum. Visit the ARTS PDF Forum on our website at http://forum.artspdf.com. 5.3. Updates To ensure you are up-to-date with the most recently released bug fixes and new features; check that you have the latest version of ARTS PDF Workshop installed. To check if your version is the latest: 1. Start Microsoft Excel. 2.
ARTS PDF Workshop User Guide Troubleshooting 5.5. Technical Support Before contacting us please read the complete Troubleshooting section as the answer to your problem may be found in the FAQs or on the ARTS PDF Forum. To contact ARTS PDF Technical Support, please e-mail techsupport@artspdf.com and supply the information below to help us replicate the problem you are experiencing. a.