Keith_Excel
New Member
- Joined
- Feb 19, 2014
- Messages
- 8
On our accounts package everytime a note is added to an account, a new .txt file is created. Our accounts package is not great for reviewing these notes so what I would like to do ideally is to have one excel workbook with two columns, the first column containing the Filename and the second column the contents of the .txt file.
The files are ever increase, we've currently over a 1000 and there is no sequence to the filenames. Does anyone know a macro that would combine all these .txt files into either seperate workbooks or ideally the same sheet. The .txt files are all stored in the same folder on the network and are the only contents of the folder.
The files are ever increase, we've currently over a 1000 and there is no sequence to the filenames. Does anyone know a macro that would combine all these .txt files into either seperate workbooks or ideally the same sheet. The .txt files are all stored in the same folder on the network and are the only contents of the folder.
