Where to Find the ACROBAT.TLB Type Library for Excel VBA Automation
Question details
The user needs to locate the ACROBAT.TLB type library to use COM automation in Excel VBA for populating PDF forms with SQL Server data.

- Product
- Excel VBA / Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Attempting to automate PDF form population via Excel VBA on a company server where Acrobat XI installation is restricted due to security policies.
- Observed behavior
- The ACROBAT.TLB file is missing because the required full version of Adobe Acrobat cannot be installed, and Adobe Reader does not provide this COM library.
Ensure you have administrative privileges to install licensed software on your server and verify your organization's security and licensing policies regarding Adobe Acrobat deployment.
Install a Licensed Version of Adobe Acrobat Standard or Pro
The ACROBAT.TLB library is exclusively included in full, licensed versions of Adobe Acrobat. It cannot be extracted or used standalone.
COM automation for PDF files requires the full Adobe Acrobat application to be registered in the Windows Registry. Simply copying the ACROBAT.TLB file from another machine will not work because the underlying executable operations are handled by the Acrobat application itself. You must install a supported, licensed version.
Check with your IT department to obtain a valid license for a recent, supported version of Adobe Acrobat Standard or Pro that complies with your server's security requirements.
Run the official Adobe Acrobat installer on the target machine or server where the Excel VBA script will be executed.
Open Excel, press ALT + F11 to open the VBA Editor, go to Tools > References, and check 'Adobe Acrobat Browser Control Type Library'. If it is not listed, click 'Browse' and locate the ACROBAT.TLB file in your new Acrobat installation folder.

Try WPS Office for Lightweight Spreadsheet and PDF Management
If deploying heavy Adobe Acrobat versions or Microsoft Excel to your servers poses security or licensing challenges, consider WPS Office. It provides a lightweight, comprehensive suite with built-in PDF tools and excellent VBA support, fully compatible with Microsoft Office formats.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the downloaded file and follow the on-screen prompts to complete the installation.
- 3. Open your VBA Projects: Launch WPS Spreadsheets and open your existing .xlsm files. Press ALT + F11 to access the built-in VBA editor and manage your scripts.

Frequently Asked Questions
Why can't I find ACROBAT.TLB on my computer?
You likely only have Adobe Acrobat Reader installed. The ACROBAT.TLB file is proprietary and is only included with licensed, paid versions of Adobe Acrobat Standard or Pro.
Can I simply copy the ACROBAT.TLB file from another computer to my server?
No. Copying the .tlb file alone is insufficient. COM automation requires the full Adobe Acrobat application to be properly installed and registered in the Windows Registry to function.
Is there a free alternative to ACROBAT.TLB for PDF automation in VBA?
Free alternatives generally involve using open-source command-line tools (like PDFtk) or third-party APIs instead of COM automation. However, using these will require completely rewriting your existing VBA code.
How do I add the Acrobat reference in the Excel VBA editor?
Open the VBA editor by pressing ALT + F11, click 'Tools' in the top menu, select 'References', and scroll down to check 'Adobe Acrobat x.0 Type Library'. If it's missing, click 'Browse' and manually locate the acrobat.tlb file.




