Shell iexplore.exe xml #

[johnbird1988]

Hello,

I have the following code below:

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Dim URL As String
On Error GoTo error4:
URL = Me.ListBox1.Column(5, Me.ListBox1.ListIndex)
    Shell "C:\Program Files\Internet Explorer\iexplore.exe " & URL, vbNormalNoFocus
    
Exit Sub
error4:
MsgBox ("Link unavailable")
End Sub

This code did work, however the URL has now changed to include a # to a specific area on a page. My URL now looks something like this:

URL= "http://myteamsite/sites/info_team/area/folder/folder%20Diagrams/subfolder/Items/File%20Name%20Test.xml#This is the location"

When I run the code above it replaces the spaces after the # with %20. This causes the screen not to navigate to the correct location on the page. Is there any way I can achieve this to navigate to the correct location?

Cheers,

John

 

[daverunt]

Hi,

you could try adding another line before the shell command to replace the %20 with a space

URL = Replace(URL, "%20", " ")

 

[daverunt]

Hi,

Overlooked......
When you pass a URL to a browser if it has spaces then it will fill those with %20 anyway. An anchor link should still work though.