Excel Web Query Parameters Error

Asked Aug 18 '17 at 06:26

Active Aug 18 '17 at 06:37

Viewed 72 times

I'm having troubles adding parameters to a Web Query that reads currency rates.

Parameter: date format that updates daily (YEARMONTHDAY) in Cell ("A1") - As ["datums"]

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

Error - in URL:

Error - in Excel:

Excel - Parameter:

edited Aug 18 '17 at 06:37

asked Aug 18 '17 at 06:26

Nikolajs

Do you even know how its works? Try open this http://www.bank.lv/vk/ecb.xml?date=20170817 – Jun Rikson Aug 18 '17 at 06:31
I have the parameter set to update every day. If I simply type in the date, it won't automatically update. – Nikolajs Aug 18 '17 at 06:36
Does anyone know how I could solve this issue? – Nikolajs Aug 18 '17 at 11:36

0 Answers0