Importing a Web Query

[Guest]

Hi everybody,

I have a little problem when importing a web query. I go to the the Data
menu and choose the "New Web Query" option. Then I go the following page:

http://www.banxico.org.mx

and click on the "Mercado cambiario" link then I clic on the yellow arrow
that is on the left of the data I want to import (in this case it is just the
money exchange rate) . When I click on the Import button, it imports the data
but also puts a legend on the left that says "Obteniendo datos ..." (in
English "Getting data ..."). I don't know hoy to modify this web query in
order that it doesn't write this legend. I try to delete it on the worksheet
but Excel keeps writing this legend every time I refresh the information.

Does anybody know how to avoid importing this legend?

Thanks in advance,

Charles

 

[Don Guillett]

Click on the url below>click on Mercado cambiario>right click>import to
microsoft excel>after imported>data>external>edit>click to turn the desired
table into a check>import>use this recorded macro,commenting out what is NOT
needed. I can send you a workbook, if you contact me privately.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/24/2006 by Don Guillett
'

'
Range("A11").Select
With Selection.QueryTable
.Connection = _
"URL;http://www.banxico.org.mx/tipcamb/llenarTiposCambioAction.do?idioma=sp"
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingAll
.WebTables = "15"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub

 

[Don Guillett]

Pesos por divisa
23/10/2006
Euro Obteniendo datos... 13.6175 Más información
Yen Japonés Obteniendo datos... 0.091
Dólar Canadiense Obteniendo datos... 9.6154



Was this the info desired?

 

[Guest]

Thank you very much for your help Don. Yes that is the information I want to
import, but I don't want the legend "Obteniendo datos..." I don't know why
Excel writes it if it is not on the web page.

 

[Don Guillett]

Contact me privately for the workbook