Display Worksheet ASP page pop-up

[Ted]

Would somone tell how to display an ASP Page instead of Internet Explorer in
a worksheet upon selecting a Hyperlink field displayed in a column? My
progam imports Data to a worksheet and selects a Hyperlink which opens a web
page in IE 6.0. Instead I would like it to open an ASP pop-up page. How do
you modify the line of code Selection.Hyperlinks(1).Follow (as listed below)
to display in an ASP page instead of IE 6.0 so that I can save it in Text
format.
'----
Sub ImportXML()
Application.CommandBars("Task Pane").Visible = True
ActiveWorkbook.XmlImport URL:= "C:\Data.xml", ImportMap:=
Nothing, Overwrite:=True, Destination:=Range("$A$1")
ActiveWindow.SmallScroll ToRight:=1
Range("E4").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub
'-------
thx,
Ted

 

[Tim Williams]

What does the hyperlink URL look like?

Maybe try NewWindow:=True

You seem to be confusing IE and ASP: these two are apples and oranges.
ASP pages display in IE (or whatever the default browser is): without
the browser nothing will display. A pop-up page is just an IE window
without buttons etc.

Tim