I have over 1,000 text files on my hard drive.
I need to add a different line of text (a cell value) to the bottom of each of these text files (without opening them)...
I have the following setup in mind...
all text file names, including path:
all the different values to append at the end of the "same row" text file:
this text (to append at the end of text1.txt)
some other text (to append at the end of text2.txt)
this text variation (to append at the end of text3.txt)
So my Excel 2003 sheet should look like this...
row1 - (A)C:\folder1\text1.txt - (B)this text
row2 - (A)C:\folder1\text2.txt - (B)some other text
row3 - (A)C:\folder1\text3.txt - (B)this text variation
Running the macro should do the following (row per row)
- append the cell value from column B to the text file in cell column A
- save the newly created text file in C:\folder2\ under the same file name.
I hope this makes sense.
Thanks for your help!!!
P.S. I use Excel 2003 and I have no VBA programming skills, so..., much obliged to anyone who can help me out here!