E
eric
Hello
I am bringing in data from the web using a macro (see below). The data fro
th
webpage gets imported correctly, however in an internet browser, one of th
columns has text with an underlying hyperlink, and I am hoping someone ca
hel
me bring that hyperlink instead of the text into Excel
For example, http://finance.yahoo.com/q?s=AAPL&ql=1 has links to many page
including "Order Book", but I would wan
"http://finance.yahoo.com/q/ecn?s=AAPL+Order+Book" to be brought int
Excel
Thank you so much!
My macro
With ActiveSheet.QueryTables.Add(Connection:=
"URL;https://www.XYZ....",
Destination:=Range("$A$1")
.Name = "Import
.FieldNames = Tru
.RowNumbers = Fals
.FillAdjacentFormulas = Fals
.PreserveFormatting = Tru
.RefreshOnFileOpen = Fals
.BackgroundQuery = Tru
.RefreshStyle = xlInsertDeleteCell
.SavePassword = Fals
.SaveData = Tru
.AdjustColumnWidth = Tru
.RefreshPeriod =
.WebSelectionType = xlEntirePag
.WebFormatting = xlWebFormattingNon
.WebPreFormattedTextToColumns = Tru
.WebConsecutiveDelimitersAsOne = Tru
.WebSingleBlockTextImport = Fals
.WebDisableDateRecognition = Fals
.WebDisableRedirections = Fals
.Refresh BackgroundQuery:=Fals
End With
I am bringing in data from the web using a macro (see below). The data fro
th
webpage gets imported correctly, however in an internet browser, one of th
columns has text with an underlying hyperlink, and I am hoping someone ca
hel
me bring that hyperlink instead of the text into Excel
For example, http://finance.yahoo.com/q?s=AAPL&ql=1 has links to many page
including "Order Book", but I would wan
"http://finance.yahoo.com/q/ecn?s=AAPL+Order+Book" to be brought int
Excel
Thank you so much!
My macro
With ActiveSheet.QueryTables.Add(Connection:=
"URL;https://www.XYZ....",
Destination:=Range("$A$1")
.Name = "Import
.FieldNames = Tru
.RowNumbers = Fals
.FillAdjacentFormulas = Fals
.PreserveFormatting = Tru
.RefreshOnFileOpen = Fals
.BackgroundQuery = Tru
.RefreshStyle = xlInsertDeleteCell
.SavePassword = Fals
.SaveData = Tru
.AdjustColumnWidth = Tru
.RefreshPeriod =
.WebSelectionType = xlEntirePag
.WebFormatting = xlWebFormattingNon
.WebPreFormattedTextToColumns = Tru
.WebConsecutiveDelimitersAsOne = Tru
.WebSingleBlockTextImport = Fals
.WebDisableDateRecognition = Fals
.WebDisableRedirections = Fals
.Refresh BackgroundQuery:=Fals
End With