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!
Don’t have an account yet? Register yourself now and be a part of our community!