Friends...
I query some data from a URL via Excel, and observed incorrect values being returned on occasion...
Correct:
On an instance browser shows 872,1830.8,1832.95,1829,1832.35,3711 at the target url
And excel retrieves 872,1830.8,1832.95,1829,1832.35,3711
Incorrect:
Another instance browser shows 873,1833,1833,1830,1831,6246 at the target url
but excel macro ends up with 87,318,331,833,183,000,000,000
Why is this different behaviour, any ideas on how to fix?
QueryQuote:
With DataSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
DataSheet.Range("a1").CurrentRegion.TextToColumns Destination:=DataSheet.Range("a1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, other:=False
I query some data from a URL via Excel, and observed incorrect values being returned on occasion...
Correct:
On an instance browser shows 872,1830.8,1832.95,1829,1832.35,3711 at the target url
And excel retrieves 872,1830.8,1832.95,1829,1832.35,3711
Incorrect:
Another instance browser shows 873,1833,1833,1830,1831,6246 at the target url
but excel macro ends up with 87,318,331,833,183,000,000,000
Why is this different behaviour, any ideas on how to fix?
QueryQuote:
With DataSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
DataSheet.Range("a1").CurrentRegion.TextToColumns Destination:=DataSheet.Range("a1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, other:=False
Last edited:
