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("");"//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?


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!