Link to home
Start Free TrialLog in
Avatar of excelismagic
excelismagic

asked on

any soltion create a connection to import XML file from website

I have this php website link  

previously, i had a link https://treasury.un.org/operationalrates/xsql2XML.php  which was working fine importing the XML data into excel using normal data connection. i had put workbook open event with Refresh.all  and it was updating my data from the XML source link.

somehow it stopped working.  if i open the link https://treasury.un.org/operationalrates/xsql2XML.php  it downloads the XML file, and if i use the downloaded XML file then it work, however, if i put this https://treasury.un.org/operationalrates/xsql2XML.php into data connection to directly fetch data, ideally it should work but it does not.

any help is appreciated.

i don't care whether it is a normal solution or VBA, as long as i can get my data updated from the source https://treasury.un.org/operationalrates/xsql2XML.php

thanks.
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

What is the PHP part of this question?  Are you looking for a PHP script that will read the XML document?
Avatar of excelismagic
excelismagic

ASKER

Ray,

i am sorry, the topic was suggestion by EE itself. i need solution in Excel.  apparently the website link has a extension of php
i am not looking for PHP script, i need help with Excel or VBA in Excel to be able to export the data from given link into Excel worksheet.

thanks.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial