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