Web Query Without URL

[Guest]

I am used to working with web queries such as the one below:


For Each c In Sheets("Sheet1").Range("B1:E1")
lstRw = Cells(Rows.Count, 1).End(xlUp).Row

str1 =
"URL;http://finance.yahoo.com/currency/convert?amt=1&from=USD&to=" & _
c.Value & _
"&submit=Convert"
With ActiveSheet.QueryTables.Add(Connection:=str1 _
, Destination:=Range("A" & lstRw + 1))

…etc, etc, etc

End With
Next c


What I can’t figure out is how a query is done when there is no URL!
Basically, a guy who is no longer with the company created a web query, and
used some technique, which I am not familiar with, to do the query. I know
the query is for foreign exchange rates, and I can tell that the query source
is somehow linked to: www.xrate.com

I can't find a URL anywhere though. I only figured out that a web query is
being done when I disconnected the Ethernet connection and launched Excel. A
message popped up saying something like Excel was unable to query a table
from xrate.com. I just can’t figure out how this query is actually done.
Can anyone shed some light on this topic for me?

Regards,
Ryan--

 

[Guest]

The query is most likely a data query that has no VBA code behind it. It is
created by choosing the menu command Data->Import External Data->New Web
Query.

To edit the query, find the table in the workbook where the results are
placed, right-click on the table, and choose "Edit Query".

Kevin

 

[Guest]

Yes, you are right! Actually, I’ve seen this before (I guess I didn’t think
of it this time). Thanks for the assist!