Hey all. I wrote a macro that goes to the internet and into my Yahoo! Finance imports the entire page, searches for the word portfolio value, goes down one cell to grab that value, brings it back to a data worksheet and deletes the imported data.
I am trying to set it up so this program runs every day after the market closes. The best way I could come up with is to use the worksheet activate event handler to run the macro and the "ontime" method to tell it to execute at 4pm. However, it is very buggy. If it does work it will grab the data about a dozen times.
I would appreciate any suggestions for a better method to accomplish this.
I am trying to set it up so this program runs every day after the market closes. The best way I could come up with is to use the worksheet activate event handler to run the macro and the "ontime" method to tell it to execute at 4pm. However, it is very buggy. If it does work it will grab the data about a dozen times.
I would appreciate any suggestions for a better method to accomplish this.
