Select a Category

How to display Adobe Reader file with Visual Basic for Application (VBA)?

Problem

It is nice to show PDF file in VBA application, such as Excel. There are not many documents on how to do it. After two days, I figured out a way to solve this problem

Solution

Microsoft provides a web browser control in standard VBA. It can be used to display various files, such as PDF file, pictures and other file.

  1. Insert Microsoft Web Browser control Insert Microsoft Web Browser Control
  2. Add Web Browser control in a form and size it accordingly. Size Control and Add Code
  3. Supply file path and name to Web Browser’ Navigate property. Web Browser opens up the file.PDF File Displaying

 

 

Comments are closed.