Hi relatively new to vba and particularly web querying.
I am basically trying to download historical data from Zurich Life Fund Prices , have found it no problem to download the prices for today, but was wondering if there was a method to download prices for 13th, 12th etc etc. I'm not sure if this is possible given the prices are all contained within scripts on the same url? Any advice/methods would be greatly appreciated. Have also considered possibly using web macros? But would prefer to use within vba and download all prices to one sheet.
kind regards
I am basically trying to download historical data from Zurich Life Fund Prices , have found it no problem to download the prices for today, but was wondering if there was a method to download prices for 13th, 12th etc etc. I'm not sure if this is possible given the prices are all contained within scripts on the same url? Any advice/methods would be greatly appreciated. Have also considered possibly using web macros? But would prefer to use within vba and download all prices to one sheet.
kind regards
