Web Query

[Tany Van aerde]

Hallo,
When we run a WebQuery (Data/Get External Data from Web) with URL
http://www.abnamromarkets.nl/showpage.asp?N=0&pageid=125&instrategy=12,
sometimes the translation is missing the decimal denominator.
ING Turbo Long should have 9,205 EUR as Reference, but it appears in the
cell as 9205.

Any suggestion is welcome.
Thanks in advance.
(e-mail address removed)

 

[Don Guillett]

Probably a Yahoo problem but if you want to send you file to my address
below I'll take a look.
I do a lot of web query work for clients especially with Yahoo. BTW I'm a
retired ING Reg Mgr.

 

[Don Guillett]

Another look at your problem seems that, IF you bring in as plain text, you
can see that Excel is treating some as numbers and some as text. Here is a
macro I often use to force numbers. Adapt to suit
Sub fixmynums()
Application.ScreenUpdating = False
'lr = Cells.SpecialCells(xlCellTypeLastCell).Row
On Error Resume Next
For Each c In Selection
' For Each c In Range("b5:i" & lr)
If Trim(Len(c)) > 0 And c.HasFormula = False Then
c.NumberFormat = "General"
c.Value = CDbl(c)
End If
Next
Application.ScreenUpdating = True
End Sub