Excel macro Open URL special character # changed

First open Excel, click on the "File" button in the upper left corner (the 07 is the Circle icon), open the options, then click on the Custom Ribbon (Customize ribbon), on the right, put the development tool (Developer) before the tick, click OK to open the development tool.

Select Insert a button in the development tool

Https://jingyan.baidu.com/article/9113f81b0c19e22b3214c78e.html

The code for button one is as follows

Activeworkbook.followhyperlink address:= "http://www.baidu.com/production/#!finder_result?global=object-id& Revs=latest&conf=no-configurations&text= ", Newwindow:=true

And actually opened the page after found #! changed to%20_%20, resulting in web pages not opening

Modify the code to

Shell "C:\Program files\internet Explorer\iexplore. EXE http://www.baidu.com/production/#!finder_result?global=object-id&revs=latest&conf=no-configurations &text= ", Vbnormalfocus

Or

Dim Web as Object    Set web = CreateObject ("Internetexplorer.application")    web. Visible = True    web. Navigate ("http://www.baidu.com/prodution/#!test=")

　　

Excel macro Open URL special character # changed