Hi, I'm using MS Excel 2010. I have a spreadsheet that is linked to a website and which imports data from the website when I open the spreadsheet. -- All good so far...
My problem is that the fastest data refresh rate is 1 minute. Although that seems quick, 1 minute is quite a long time for some internet data. I need to be able to code a way into the spreadsheets VBA module that will update the data at a custom rate.
I tried to use the "RefreshAll" command, but that really doesn't work. So, my question is - how do I programmatically update my website data inside my spreadsheet?
The data that I'm importing is financial data, so a simple example would be a stock quote. In that example, my question would be - how do I "programmatically" update the data from the webpage via the spreadsheet?
Thank you very much of your help.