Hello!
I need a macro that will be able to import a few text files into the workbook. This text import macro should open the ASCII files located in a specified folder one by one – leaving out the last column. The first column is the dates column and should be imported as text. In the attached worksheet I created two tabs – RAW and READY. I am not sure if there is any real need for the RAW tab as I thought it could be used for initial import of the text file for subsequent copying to the READY sheet. If this is not necessary the data should be imported starting from A1 cell on the READY sheet. The colored section of the READY sheet should be cleared after each import – more precisely – the area from A1 to E5000. And the last request - the name of the text file should be entered into the H1 cell on the READY tab after each data import.
Any help will be hugely appreciated!
PS: I have attached both the workbook and the data files, which are historical stock price history:
http://rapidshare.com/files/259676044/IMPORT.zip.html