G'day
This is probably a simple question, but using VB what code do I need to have a text file imported into a worksheet. I have about 200 files in one directory that I want to import one after the other. Is there a way to get VB to import one, complete the macro that I want to apply (it does some calculations then prints and saves the workbook) and then automatically open the next .txt file in the directory and do it all again until all the files have been processed ( and then stop)?
thanks in advance
Cheers
ken
This is probably a simple question, but using VB what code do I need to have a text file imported into a worksheet. I have about 200 files in one directory that I want to import one after the other. Is there a way to get VB to import one, complete the macro that I want to apply (it does some calculations then prints and saves the workbook) and then automatically open the next .txt file in the directory and do it all again until all the files have been processed ( and then stop)?
thanks in advance
Cheers
ken