WebBrowser.Navigate 64bit

  • Hi there,

    to view a PDF file I use the WebBrowser.Navigate command (adding the URL of the PDF file on the network) in a usf in which I have inserted a webbrowser control.


    With 32-bit office 2007 it works without problems. On the PC where I have installed 365 64 bit it crashes and closes excel.


    With the same command if, instead of pointing to a PDF file, I try to open a website (Default.aspx) it works without problems.

  • Since you are using 365, you can read a PDF by bringing it into Power Query called Get and Transform Data and found on the Data Tab. Click on Data-->Get Data-->From File-->PDF. It will open in the PQ Editor. If you don't wish to make any changes to it, then click on Load and Close and it will bring it directly into Native Excel.


    To get this info from a web site, use the same methodology but select From Web and enter the URL.

  • Thanks for reply.

    Actually my file have be used in several PCs where should be installed any versions, from 2007 32 bit to 365 64 bit.

  • It seems that the support for Internet Explorer (which is used by WebBrowser control) ends since August 17, 2021


    I changed the code:


    Code
    ActiveWorkbook.FollowHyperlink Address:="http://www.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!