Microsoft Access VBA - Programming. xml which contains information about the content of your library. Adobe Acrobat is the original standard program for creating, editing, and viewing PDF files. Then you have the program junkies who like to do things like menus, calendars, and the occasional little newsletter-like things, that require the addition of some. The 'Adobe Type Library Reference Book' is not for the casual user! The casual user is normally comfortable with the fonts that come with their computer and their associated programs. We need add 'Microsoft Activex Data Objects Library' from References to reference the ADO in VBA. Adobe InDesign CS3 Scripting Tutorial Getting Started 6 Many applications contain Visual Basic for Applications (VBA), like Microsoft Word, Microsoft Excel, Microsoft Visio, or AutoCAD. Techyv is one of the leading solution providers covering different aspects of Computers and Information Technology. (NOTE: Planning to build or manage a VBA Application? Learn how to build 10 Excel VBA applications from scratch. Related Training: Get full access to the Excel VBA training webinars and all the tutorials. I do not have either such things in my tools references. 0 and I have checked the library adobe. What I would really prefer it do is open either a folder (from hyperlink path in query) or PDF (with default application), as some of the records may or may not not. This macro is equivalent to selecting the cells A1 to A6 and clicking on Selection To Barcodes on the toolbar. Would you mind pointing me to the right direction in order for me to get that library. 5 million free CAD files from the largest collection of professional designers, engineers, manufacturers, and students on the planet. Scroll to the bottom and click Show all Bookmarks. you need to Adobe Acrobat installed to run this code open attached excel file click Import PDF button then 'PDF Import' form will show select PDF file import select option to import into Excel or Text file tick checkbox if you want each page in each excel sheet if you select text file option then select folder location save text files. Oct 2nd, 2019 - ExpertPdf HtmlToPdf Converter v14. The 'Adobe Type Library Reference Book' is not for the casual user! The casual user is normally comfortable with the fonts that come with their computer and their associated programs. If that PDF already exists, you are asked if you want to overwrite it. Download this app from Microsoft Store for Windows 10, Windows 8. Microsoft Access / VBA Forums on Bytes. Stream Object (ADO) 01/19/2017; 2 minutes to read; In this article. How can it be done? Following the steps: Step 1. Regular Expression Library provides a searchable database of regular expressions. Key Features. End of search results. OLB in Office16\Program Files(x86) dated 5/8/2016. The Excel file has all the modules and all the references included to be able to use once downloaded. Documentation on Adobe® Photoshop® CC 2019 scripting is now available. Using Excel, you can readwrite to PDF fields and other controls. Domain Aggregate functions are specific to Microsoft Access because they are used to retrieve data from tables. Adobe Acrobat and VBA - An Introduction Update: Please visit the same post on my business site. Free, Safe and Secure. Techyv is one of the leading solution providers covering different aspects of Computers and Information Technology. If it doesn’t automatically open, right-click the file, select “Open With,” and choose Adobe Reader. The easiest way is with Adobe Acrobat Pro version, you have almost total control from Excel. Compiling an AIR component or code library (Flex). I made this free Excel VBA training program so you can learn how to get better at VBA and reclaim your time, too wellsr. Display results with all search words. Reading PDF Form Fields with VBA When I check the References again, it was not the "Acrobat" selected, but the Adobe Acrobat 9. In addition to the improvements discussed there, including connecting the applications you build to the data and services available in Office 365 and creating add-ins that connect to third-party services, we continue to support developers working in VBA by adding new. The following code runs more slowly. Adobe Photoshop is probably the most famous raster graphics editor that is available on the market for almost three decades. 500+ Colours. The latest. Its source code is included in our Android SDK, helping you build amazing apps, faster. GetElement in IE using VBA. Learn how to build 10 Excel VBA applications from scratch. Related Training: Get full access to the Excel VBA training webinars and all the tutorials. Therefore I've searched for other software to do this and I've found that Nuance Power PDF could be a good option. Now I have done it with each new version of Illustrator but I always forget and Adobe’s instructions for it just don’t work (close all documents, select the colors you want to be default and close. AcroPDDoc Dim adAcrobatApp As New Acrobat. 0 Type Library Go into Object Browser See if you can get a VBA Sub going that looks like this:. Adobe Photoshop CS5 Object Library: Contents : JavaScript Reference Guide. Execute the VBA procedures from the Immediate window. I've taught myself enough over the years to be dangerous, but since I only need to script things once in a blue Using Acrobat PDFMaker Add in from VBA - VBA Visual Basic for Applications (Microsoft) - Tek-Tips. ABOUT AUTODESK Autodesk is a leader in 3D design, engineering and entertainment software. I suspect correctly registering the OLB would have solved my issue. Adobe Illustrator CC 2017 supports scripts written in AppleScript, JavaScript or VBScript. Supports JavaScript & PHP/PCRE RegEx. If VBA cannot locate the Microsoft SOAP Type Library 3. Quoting from the latest (October 2009) Adobe Acrobat 9. AcroPDDoc Dim adAcrobatDoc As Object The above two lines i declare in genr. Microsoft Scripting Runtime), go to the VBA editor and open the immediate window (CTRL+G). Within the free Adobe Reader you can add notes and highlight text. This tutorial will teach you how to insert a PDF file into a set of existing plans. Adobe Acrobat and VBA - An Introduction Update: Please visit the same post on my business site. NET developers joined together with a common goal: to learn, teach, and have fun programming. VBA includes several built-in operators and functions, which can be used for building expressions or performing tasks in your VBA code. Below is the final image we will be working towards. Develop Bring Your Ideas to Life. Display results with all search words. Fire up Adobe Reader – you should find it in your Start menu. When you create a new file in a form library, the default program can be an XML-based form design program that is. The question that usually follows is "How do I save PDF files from Adobe Reader to SharePoint?" - a great question and in this post I'll show you how. connection VBA Reference helps as to refer ADO in Excel VBA. Join today to get access to thousands of courses. Probably the most complicated aspect of using motion paths is continuing the motion from slide-to-slide. A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis skills to the next level. Think of the Term Store as 1 big box of metadata labels that can be references from any SharePoint Site or Site Collection. The cause of the problem is usually a reference to a non-default object library – for example, if you are working in Excel but need to automate Word or Outlook, you will typically set a reference to the required library and then happily program against it. Except where otherwise noted, work provided on Autodesk Knowledge Network is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3. Problem occurs if the procedure contains a VBA function and if your database contains a reference to a missing object library or a missing type library. (Windows) For Microsoft Office documents, the Adobe PDF printer does not include some of the features that are available from PDFMaker. However, a few could easily move into your code library as is. NET Developer Tools - Components. Judging from the blog stats, the subject of opening PDF files using VBA code is really popular. The most prominent way to do this, is to use a DataObject variable from the Forms library (language). Stream Object (ADO) 01/19/2017; 2 minutes to read; In this article. Tek-Tips Forums is an intelligent work forum community for Information Technology professionals. Sign up today and get $5 off your first purchase. I have Adobe X1 Standard installed on my computer. I discovered this recently when moving to a new machine with a 64bit edition of Windows 7 installed. Same errors Type mismatch trying to instantiate the application. cguarini. Scharpff RI Learn in this ebook to edit (recorded) macros and to design software code and forms to add additional functionality to the popular Excel spreadsheet program. If you are unable to find your form here, you may want to visit: Request for DD 214 or other Military Records NARA SF 180; GSA Library of Standard and Optional Forms. Below is an example of moving the mouse to the top left of the screen and then clicking. I do not have either such things in my tools references. It then uses the Adobe Acrobat 5. Adobe InDesign (of course) Adobe Acrobat Pro (if you don’t have Adobe Acrobat Pro, check the other alternatives at the bottom of this post) Let’s see the simple steps to take. Please see the Autodesk Creative Commons FAQ for more information. Compare Ranges Vba in title. So I try to adapt the Excel VBA macro to automatically control Nuance Power PDF. Download books for free. We can use ADO in Excel VBA to connect the data base and perform data manipulating operations. How to read or access the clipboard with Excel VBA? You can access and retrieve the data in the clipboard into a variable in Excel VBA, using the Microsoft Forms library. x\Acrobat\Acrobat. A Do Loop can be used in VBA to perform repetitive data manipulation and improve and Excel model. When you move the excel file with this VBA project to that another computer, where the Adobe Acrobat is not installed, then this reference is, well MISSING, which is expected. Can you please help with requirement?. 0 and Adobe Acrobat 10. Sign In with an Adobe ID. 1 INTRODUCTION Excel is the most admired tool for financial planning, modeling, analysis, and forecasting. you need to Adobe Acrobat installed to run this code open attached excel file click Import PDF button then 'PDF Import' form will show select PDF file import select option to import into Excel or Text file tick checkbox if you want each page in each excel sheet if you select text file option then select folder location save text files. Adobe Acrobat 10. 0 Object Library for the code to work. DLLme Adobe Acrobat Filename Acrobat. Re: Adobe Acrobat 10. This course is ideal for those involved in managing the daily operations of a business. Hi, I am wanting to use VBA with Adobe Ill CC2014. Select the "Adobe Acrobat 7. NET language. The best way to learn VBA (on your own) is to record what you do and then examine the code that is created. Using the New UserInfo Object in VBA for Microsoft Dynamics GP 10. Z-Library single sign on | Z-Library. VBA (Visual Basic for Applications) is the programming language and environment for advanced users of Excel and other Microsoft Office products to automate computing operations and extend Excel func-tionalities. It also highlighted the dimension line”DIM pdf As PDFCreator. 2 hours ago, on March 12 2018 Adobe released CC2018 version 22. "MISSING: Adobe Acrobat 10. Consequently the program will not compile. value = “orksheet”), move the cursor into the input form (itm. pdf file to excel file,like in code below which copy data. Inconsistencies and data corruption can result from referencing the wrong library for your version of Access. Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. x\Acrobat\Acrobat. 0 Type Library and Adobe Reader 9. Some time ago I needed a TIFF to PDF converter. Python has a lot of libraries for PDF extract,many of them have been discussed below. Welcome to the Adobe Acrobat SDK Documentation. 0 Object Library OLE Automation Adobe Acrobat 9. 'In order to use the macro you must enable the Acrobat library from VBA editor: 'Go to Tools -> References -> Adobe Acrobat xx. If you don’t choose this option,. Display results with all search words. Like finding out the missing library or the cause of mismatch if it exists. Except where otherwise noted, work provided on Autodesk Knowledge Network is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3. Manipulating Adobe PDFMaker Office Add-in Preferences using VBA. 1 documentation, "There is currently no support for the development of plug-ins using managed languages such as C# or VB. Solved: Hi,I am much new to the vba as well as for the Adobe Forum. With annotations and markups, users can communicate with each other by writing comments and drawing shapes on top of the document without making permanent changes. In Office XP, the VBA project contains a reference to the Microsoft SOAP Type Library 3. Here's how you can use the OCR tool built-into Adobe Acrobat to turn your scanned documents and pictures of text into real digital text. In tree-structured hierarchies such as a file system or an e-mail system, a Record may have a default binary stream of bits associated with it that contains the contents of the file or the e-mail. The first step is to pin the application to the taskbar, and second, make Acrobat or Reader the default application for opening. Theano, Flutter, KNime, Mean. or 11 not 12 for 2003. I lost a $4000 job because of this. Net windows application what libraries are needed? I have Adobe Acrobat Reader 7. 0 Type Library to merge the resulting PDFs into a single PDF document. 0 Object Library - Microsoft XML, v6. Examples Add a simple listener. GitHub Gist: instantly share code, notes, and snippets. Sign up for classes today!. Support for Adobe Acrobat DC 2017 has been added only in WinEdt 10. Manipulating Adobe PDFMaker Office Add-in Preferences using VBA. If you do not have SDK, you can download it from the following links. 0 Type Library instead of Adobe Acrobat 6. Examples Add a simple listener. Single Sign-On. Opening the offending file in safe mode Recompiling the VBA (VBE > Debug > Recompile VBA Project) "Can't find project or. 0 so you might need to check that it's the same for your version of Adobe (ToolReferences in the VBA editor). PDFsharp is the Open Source library that easily creates PDF documents from any. Sample scripts are included in the Adobe Illustrator CC 2017 installer and are installed with the product. The list of features includes text selection, printing, adding bookmarks, and zooming among others. Automation of Acrobat with VBA I would look at some of the products out there that are designed specifically to merge PDF files. The downside is that you now have more layers (e. ONLC offers instructor-led training classes in Denver, Colorado for Excel version 365, 2019 2016, 2013, and 2010 and at levels for those new to Excel on up through advanced training and prepare for MOS certification. In the pop-up, click Select Folder. The name of the DDE service is, in the case of Acrobat DC Pro 2017, AcroviewA17, while in the case of Adobe Reader DC 2017, AcroviewR17. The reason I cannot complete this step is because Adobe Illusterator CS6 Type Library does not appear in the list of available type libraries. The Training Day Our courses run from 9. Go into the VBA IDE (Alt-F11) Go into Tools->References Check all the Adobe Libraries I have: Adobe Acrobat 7. I set up some basic, manual reports using Highcharts back in August 2014, and since then we make a JSON request to Adobe Analytics and pass the data back to HighCharts. how do I clear forms in adobe acrobat dc. 0 Object Library - Microsoft XML, v6. I think if you add the acrobat library in your references, you can declare a variable for the pdf file type and get some some help. Check, or uncheck, the Display PDF in Browser as you wish. What is Xpdf? Xpdf is a free PDF viewer and toolkit, including a text extractor, image converter, HTML converter, and more. I am good up to here, but whenever I try to browse I can never find this file. The template is referenced to the Adobe Acrobat Browser Control and the AcroPDF object is available in the toolbox. Write for example ?TemporaryFolder into the immediate window and press enter. Teresa Szumiglala, Director of Human Resources, Erie School District Since 2004, we have been beyond satisfied with the outstanding personal service provided by VBA and the quality of the benefits our employees have received. Macros/Scripting/Automation. Update the gPDFPath to point to your own PDF and let me know what. Visual Basic for Applications (VBA) functions break in a database with missing references. To attempt this multiple choice test, click the ‘Take Test’ button. During the early days of the dot com boom, our online PC main. In Visual Basic, from the Project menu, select References. Represents a stream of binary data or text. 0 Type Library Go into Object Browser See if you can get a VBA Sub going that looks like this:. The Adobe PDF Library SDK is available from Adobe through a license agreement to OEMs, ISV integrators, and enterprise IT developers on a case-by-case basis. Why does Adobe have to be so difficult?? ARGH!! I want to query the currently installed version of Acrord32. Therefore I've searched for other software to do this and I've found that Nuance Power PDF could be a good option. Visual Basic For Applications This is the library that defines the VBA language. I'm not presently on my work computer, and as such don't have access to acrobat X to double check this, but the code you are (were) asking for will look something like this:. 0 With the release of MS Dynamics GP 10. Scanning into Microsoft Word from Version 2007 onwards Word 2007/2010. You may need to adjust some of it according to work in VBA. VBA -> ADO -> OLEDB -> ODBC -> SQL Server) but at least you would be able to continue to leverage features in ADO that are not available in DAO. VBA-Code-Library. Create barcodes with VBA and macros in Microsoft Excel. Select the "Adobe Acrobat 7. 0 Object Library' after reference is saved. This article describe how you can convert Microsoft Word documents to Adobe PDF documents using a command line VBScript and Automation. 0 so you might need to check that it's the same for your version of Adobe (ToolReferences in the VBA editor). The Excel interface makes it easy to create rich data visualizations, PivotTable views, and professional-looking charts. I need to convert. If the reinstall of any of the Microsoft® Office addins described above fails, please run a repair of Engagement. You use Recordset objects to manipulate. Snippet Manager, Insert Snippet and Store to Snippets modules are used to work with codes library, insert a fragment from snippets to the project or record interesting fragment to the library. I will start by showing you how to filter your data. JC Zalog’s suggestion is good advice, but is specific to a problem that was common around the time the question was originally posted. A script is a series of commands that tells Illustrator to perform one or more tasks. 0 Professional programmatically using Visual Basic for Applications, such as from Microsoft Access let's say. In addition to the improvements discussed there, including connecting the applications you build to the data and services available in Office 365 and creating add-ins that connect to third-party services, we continue to support developers working in VBA by adding new. Beyond Online Learning. Single Sign-On. In some cases, advance registration is required and can be completed by clicking on the event's "Register Now" link. VBA-Code-Library. If you haven't set a reference to the Excel type library, you must declare the variable as a generic variable of type Object. Most of the tools are available as open source. Hi, I am wanting to use VBA with Adobe Ill CC2014. This video series has been designed to explain the basics of VBA with simple and useful examples. Join today to get access to thousands of courses. 0 Browser Control Type Library 1. Look for the function/method name in the "Member" column, and simply copy what is in the "Library" column. I want to make an excel macro to update fields. The cause of the problem is usually a reference to a non-default object library – for example, if you are working in Excel but need to automate Word or Outlook, you will typically set a reference to the required library and then happily program against it. Kenneth I already selected "acrobat" but after clicking "References" I found it changed to "Adobe Acrobat 10. The 'Adobe Type Library Reference Book' is not for the casual user! The casual user is normally comfortable with the fonts that come with their computer and their associated programs. Library Reference For Scripting. The Adobe PDF Library SDK is available from Adobe through a license agreement to OEMs, ISV integrators, and enterprise IT developers on a case-by-case basis. 0 Pro and VBA - Adobe Acrobat SDK. The most prominent way to do this, is to use a DataObject variable from the Forms library (language). I lost a $4000 job because of this. Files compatible with SharePoint technologies For a user to create a file by using the New command in a document library, the file template must be created from a program that is compatible with SharePoint 2010, such as Word 2010. Create assets using Creative Cloud applications, and then easily access them across other desktop and mobile apps for a seamless creative workflow. 0 Type Library. These settings don’t convert image colors into CMYK. I believe that it is looking for it in C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroCEF but on inspection is not present. actually no. [email protected] I'm using the following subroutine in a Microsoft Access VBA module, which successfully opens a PDF doent that is on the local hard drive: Private Sub OpenAcrobat() Dim AcrApp As AcroApp, AcrDoc As AcroAVDoc Dim varBool As Boolean Set AcrApp = CreateObject("AcroExch. I was told I needed Adobe Professional on my machine to create PDF files. Any suggestions??. 0 referenced Also, I know that Adobe is being referenced and working, as the PDF shows when I get to AcroExchAVDoc. How to move and click the mouse in VBA? You could use Excel VBA to move the mouse and click on things (left and right click). USAJOBS is the Federal Government's official one-stop source for Federal jobs and employment information. 0 Unported License. src = txtFile. Where do I get Xpdf? Download XpdfReader. It thus gets tested and updated with each Spark release. Hi, i wrote a little app in excel (VBA) to fill a pdf and it is working perfectly on my laptop, i have Adobe Acrobat pro DC, but when i use it on another laptop i get an error: "Project or Library not found", the other laptop has an Acrobat Pro XI, and i have already included all the Acrobat libraries in references. 15pm with plenty of refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch. com and fill a search form. Path path1 = path1 & "/31700100". The Excel interface makes it easy to create rich data visualizations, PivotTable views, and professional-looking charts. 0 Type Library Adobe Acrobat 7. The only one you need. 5 installed and within Visual Studio. 25% OFF Excel for Operations Management. Hello Guys, I need to pull some data out of PDFs, the current method I have uses sendKeys, and then puts clipboard contents into variable which I find really, really unreliable. 0) you have installed to your PC. Compiling an AIR component or code library (Flex). exe D:\test. Udemy is an online learning and teaching marketplace with over 100,000 courses and 24 million students. Except where otherwise noted, work provided on Autodesk Knowledge Network is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3. LOONLCWEXP13 (Rev 1) English Student. Use the ‘Next’ button to move on to the next question. Want to note that it can be more powerful than what you have displayed though in that it can get text from individuals blocks of text boxes or other objects, which may be more succinct / helpful (or not) to the OP than just grabbing all text on page - Scott Holtzman Mar 28 '16 at 20:52. Kenneth I already selected "acrobat" but after clicking "References" I found it changed to "Adobe Acrobat 10. I have only played with it for a few hours, and I was quite surprised by the results. VBA -> ADO -> OLEDB -> ODBC -> SQL Server) but at least you would be able to continue to leverage features in ADO that are not available in DAO. What I would really prefer it do is open either a folder (from hyperlink path in query) or PDF (with default application), as some of the records may or may not not. Re: Adobe Acrobat 10. Beyond Online Learning. Learn basic skills and important concepts of VBA programming including variables, forms and arrays. Add sound fx to your video, film, or powerpoint presentation. ABOUT AUTODESK Autodesk is a leader in 3D design, engineering and entertainment software. Join today to get access to thousands of courses. NET language like C# or VB. For different situations some solutions to rectify the problem or to repair corrupted Excel file are always there. I'll cover the following topics in the code samples below: Microsoft ExcelAdobe, Macro, VBA, Application, and GetObject. Manipulating Adobe PDFMaker Office Add-in Preferences using VBA. The code is written to save your PDF in the same folder as the Word Document file currently resides. Dummies has always stood for taking on complex concepts and making them easy to understand. Supports JavaScript & PHP/PCRE RegEx. com - Learn VBA and start reclaiming your time wellsr. ) Get the Free eBook. Well, My VBA reference issue fixed itself. 3 ways to use the Title field in a SharePoint list or library Posted on January 18, 2018 | Step by Step Instructions I am sure you saw this appear and wondered what it is for. Ultimately, I want to search the pdf and put the first five characters following the found text from the. For each class, we offer certifications, which in turn have shown proof of their new skills. Below is a simple VBA macro that will allow you to quickly turn your Microsoft Word Document into a PDF file in a snap. The Adobe Acrobat User Community is a global resource for users of Acrobat and PDF, with free eseminars, tips, tutorials, videos and discussion forums. I suspect correctly registering the OLB would have solved my issue. It thus gets tested and updated with each Spark release. Access 2000 and 2002 do not include a reference, by default, to the DAO 3. New post "Fundraising results, new book uploader, send to Kindle update and improved Top Zlibrarians" in our blog. In this scenario, Access is the client and Word acts as the server. Below you will find VBA code for writing and reading data from Test Form. Net 2003 I have added a number of references to the project for adobe/acrobat: Acrobat Access 3. Most of the tools are available as open source. Go to the location in the document library where you want to create a new file. Excel VBA Operators. pdf file to excel file,like in code below which copy data. Currently downloading from the Adobe website for a 30 day free trial so if this works, I might need to buy a subscription!. Vba: Close Adobe Reader - Excel Under references I have added the Adobe library. The Adobe PDF Library SDK is a low-level PDF library that contains a powerful set of native C/C++ APIs with interfaces for. Re: Read pdf file via VBA by HansV » 27 Mar 2011, 13:09 If you have Adobe Reader, you may be able to use the Adobe Acrobat n. You simply can't create object from type, which is not registered on that another computer, that's it. 0) you have installed to your PC. PDFsharp is a. You can upload the pdf to SharePoint directly from your pdf application of your choice. In the dialog that appears, select the check box for Adobe Illustrator CS6 Type Library, and click OK. You’ve completed the beginner course in VBA – or you’ve used VBA in your personal life or at work. The example below shows how to call Macro2 from Macro1. Over that, it revolutionized the graphic designing vertical which further inspired millions of artists worldwide. Thread starter daveyc3000; Start date Only need the Adobe Acrobat XX. Sign in Without Adobe Id. Simple, Jackson Annotations, Passay, Boon, MuleSoft, Nagios, Matplotlib, Java NIO. Read PDF - Adobe Reader using Excel VBA. 0 Object Type Library" listed as a reference. Adobe photoshop lightroom Freelance Jobs Find Best Online Adobe photoshop lightroom by top employers. I lost a $4000 job because of this. Adobe doesn't recommend or support use of the AcroPDF. Team, VBA Code to read data from PDF - Adobe Reader and put data into excel. Learn software, creative, and business skills to achieve your personal and professional goals. In Adobe PDF Preset, select the PDF/X-4:2010 settings. NET language. Join Coursera for free and transform your career with degrees, certificates, Specializations, & MOOCs in data science, computer science, business, and dozens of other topics. How to access and remove form's items. However, Office 2003 uses the Microsoft Office SOAP Type Library 3. Consequently the program will not compile. 1 documentation, "There is currently no support for the development of plug-ins using managed languages such as C# or VB. For demonstration purposes, I have created a sample conference PDF form (Test Form). I had to add the Adobe Distiller library to VBA, mine is for Acrobat 6. I have now migrated the VBA application to Office 2010 (64 bit) and although the template is still referenced to the Adobe Reader control, the AcroPDF object is not available in the toolbox. According to the code comments, the reference renames itself 'Adobe Acrobat 9. The Excel file has all the modules and all the references included to be able to use once downloaded.