New Web Query not recognizing tables from URL for automatic refresh

Hi All,

I have a URL for a web query http://www.bnr.ro/files/xml/nbrfxrates2015.htm. I am looking to past this onto a sheet as is on the website, but when I cannot see the yellow markers to import the table. I have to physically copy, format and paste this every day, I have a few files like this for other countries bank exchange rates which has to be used. Is there a macro to trick the web query into extracting the table from the URL

Thanks in advance for any help..

Hi pidnani,

The website is getting it's data from the URL http://www.bnr.ro/files/xml/years/nbrfxrates2015.xml
You should web query this one.

Regards,
Rick

Thanks, this one works however http://www.cnb.cz/en/financial_marke....txt?year=2015, this one brings up a really strange format..... do you know any fix

Hi !

The link display in a webbrowser could be odd but it's not at all a strange format !
As you can check yourself by downloading file and open it with wordpad :
just a text file with a delimiter separator, very common …