Display a PDF in MS Webbrowser control when PDF is selected (clicked) from a ListBox
Hello Everyone.
I hope this post finds everyone to be in high sprits.
Upon searching the highs and lows of internet I have found this forum and I am hoping that someone will be able to help me with my predicament.
First of all I must clarify that I am not using Office 2021. I am using Office365 paid subscription which is not on the list when registering here.
I have a long word document which I edited after watching some YT videos and added bookmarks on the desired locations on the document. Document is saved as Macro enabled file. I made a simple user form in VBA, watched some more YT videos and after some trial and error I managed to submit the data in correct bookmark positions successfully.
The userform is inside a tab (two pages) first page is the form/bookmark fields and the other page is where there is a ListBox and a WebBrowser. ListBox (after even some more YT videos) shows the correct files (PDF format only files) from the desired location.
The predicament is that I need the PDF shown in the WebBroswer which is under the ListBox on tab page 2 and I cannot find anywhere and I have looked and looked for a solution for this.
When the user form loads up the ListBox is initialised and populates it with all the PDF files in that particular folder.
I would really appreicate if anyone can help me with the code on how a PDF will be shown in WebBrowser control if it is clicked.
This is the only functionality missing from the user form which is preventing it from being actually used.
I can post the existing code if it is needed. The ListBox is lablled as ListBox1 and WebBrowser as WebBrowser1.
Your help is highly appreciated.
|