I would like to be able to connect to a URL in access and store the response in a variable to display on a report.
I use this code in Excel:
With ActiveSheet.QueryTables.Add(Connection:= _
"URL; & [A3], _
Destination:=Range("p32"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
The response is a price quote from Yahoo Finance. I would like to store that to a variable in Access VBA. Any help is appreciated.
Mike
I use this code in Excel:
With ActiveSheet.QueryTables.Add(Connection:= _
"URL; & [A3], _
Destination:=Range("p32"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
The response is a price quote from Yahoo Finance. I would like to store that to a variable in Access VBA. Any help is appreciated.
Mike