Forum Discussion
Import from web - dynamic year today range
Dear All! I would like to ask for your help with the following case. I have a website to import data from on daily basis. Importing data from a specific date till today. I have the problem with...
Please change your Source line to this.
Source = Web.BrowserContents("https://www.mnb.hu/arfolyam-tablazat?deviza=rbCurrencyActual&devizaSelected=ZAR&datefrom=2022.02.12.&datetill=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy.MM.dd.") & "&order=1"),
Pat
Please change your Source line to this.
Source = Web.BrowserContents("https://www.mnb.hu/arfolyam-tablazat?deviza=rbCurrencyActual&devizaSelected=ZAR&datefrom=2022.02.12.&datetill=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy.MM.dd.") & "&order=1"),
Pat