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:
Launch Microsoft Excel by clicking "Start," "All Programs," "Microsoft Office Suite," "Excel."
Open the developer environment by clicking the "Developer" tab at the top of the Excel window.
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.
Enable the Acrobat framework libraries. Click "Tools" then "References." A dialogue box will appear. From the list provided, select "Acrobat" and click "OK."
Copy and paste the PDF merger code (see Resources) to the VBE.
Change "C:\temp\Part1.pdf" to the path of the first PDF you would like to combine.
Change "C:\temp\Part2.pdf" to the path of the second PDF you would like to combine.
Change "C:\temp\MergedFile.pdf" to the path of the combined PDF you are creating.
Save the document by clicking "File," "Save." You will be prompted for a name, type "Excel Macro-Enabled Workbook", then press "Enter."
Click the button to merge the two PDFs.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for