- Oct 20, 2005
Hello all Excel Guru's. I'm not a programmer, but I was just wondering if anyone knew the quickest and easiest way to download my yahoo portfolio stock symbols into an excel spreadsheet. A web query won't return the data I hear because of yahoo's formatting of tables. I'm running office 2000 on windows xp. I tried a macro to scrape the information, and to download the information, but I always get run-time, etc. errors. Does anyone have a spreadsheet that does this, or know of the easiest way for me to get this info. I don't really understand the programming of macro's in vb. I've read the other posts, but don't get the programming part. I've tried everything I think. Can anyone help, Please! Thanks.