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.
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.
What is the PHP part of this question? Are you looking for a PHP script that will read the XML document?
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.