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:
Other People Are Reading
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