PDA

View Full Version : VBA for Investment



vinhp2013
05-07-2013, 02:45 AM
In my attached excel file that I get from the website of investexcel and it can do: Download all financial data with symbols from Cell A11 (Worksheet: Parameters) to last row of column A. The results that all symbol data is copied to new sheet with name sheet is DATA.
I have a situation. I want to download all data to sheet DATA (it is created before) and don't delete other sheets. In sheet DATA, Cell A1 contains the symbol name of the first symbol in Cell A11, and Cell A3 with data downloaded ... Do it again with the second symbol begins in Cell H1 ... To the final symbol.
If you know to modify this code. Please, help me as soon as possible.
Thank you.