Getting data daily in columns by calling WEBSERVICE/FILTERXML function

Dear All,


I am pretty much new in VBA world, so I hope someone could help me

I am calling WEBSERVICE function to get data in excel cell.
From A1 to A15 I have formulas like this =FILTERXML(WEBSERVICE("http://10.21.22.149/services/user/values.xml?var=C37-6kV.NAE");"//value"), and I get values (numbers).



My question is:

Is it possible in VBA to write a commands to automatically daily refresh (every day at 07:00) this column (A1:A15) and to paste new values in new column (B1:B15), next day refresh and paste to (C1:C15), next day to (D1:D15)?

If it is possible, would someone explain to me how, or even write a commands in VBA?



THANKS VERY MUCH IN ADVANCE!