How to merge two pdfs in acrobat 9 by vba

Written by christopher hanson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to merge two pdfs in acrobat 9 by vba
VBA automates the process of merging PDF files. (document image by AGphotographer from Fotolia.com)

Visual Basic Applications, or VBA, is a programming language used for modifying existing programs. Adobe Acrobat is a program used to view and manipulate Portable Document Format, or PDF, files. The Visual Basic editor, or VBE, in Microsoft Excel enables programmers to access the framework of a program and edit the user interface of the program. Thus, Excel's VBE allows programmers to create buttons that access the Acrobat framework but perform functions that aren't available in Acrobat---in this case, merging two PDFs.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Launch Microsoft Excel by clicking "Start," "All Programs," "Microsoft Office Suite," "Excel."

  2. 2

    Open the developer environment by clicking the "Developer" tab at the top of the Excel window.

  3. 3

    Insert a button. Click "Insert," "Control" then select a button and drag it onto the main panel of the development window. A dialogue box labelled "Assign Macro" will appear on the screen. Click "Add" and the VBE will appear.

  4. 4

    Enable the Acrobat framework libraries. Click "Tools" then "References." A dialogue box will appear. From the list provided, select "Acrobat" and click "OK."

  5. 5

    Copy and paste the PDF merger code (see Resources) to the VBE.

  6. 6

    Change "C:\temp\Part1.pdf" to the path of the first PDF you would like to combine.

  7. 7

    Change "C:\temp\Part2.pdf" to the path of the second PDF you would like to combine.

  8. 8

    Change "C:\temp\MergedFile.pdf" to the path of the combined PDF you are creating.

  9. 9

    Save the document by clicking "File," "Save." You will be prompted for a name, type "Excel Macro-Enabled Workbook", then press "Enter."

  10. 10

    Click the button to merge the two PDFs.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.