Excel Web Query Issues -


i'm having troubles adding parameters web query reads currency rates excel cell. need read through cell because data needs updated , date formatting different standard format.

parameter: date format updates daily (yearmonthday) in cell ("a1") - ["datums"]

url: http://www.bank.lv/vk/ecb.xml?date=["datums"]

error - in url: enter image description here

error - in excel: enter image description here

excel - parameter: enter image description here


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -