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.
- Insert Microsoft Web Browser control
- Add Web Browser control in a form and size it accordingly.
- Supply file path and name to Web Browser’ Navigate property. Web Browser opens up the file.
