Answer for your questions are here..
1. Yeah, you can delete a file from within a spreadsheet using 'Kil
filepath( you want to delete)'.
2. Yes, you can append the text files by copying and pasting them in
spread sheet. For doing it perform these steps.
A. Add Microsoft Scripting Runtime reference to your project.
B. Use FileSystemObject form it.
C. By Using Collections i.e For Each File in Directory, open each tex
file, delemit the text, copy it and paste to your spreadsheet

--
gajendra_vb
-----------------------------------------------------------------------
gajendra_vba's Profile: http://www.excelforum.com/member.php...fo&userid=2993
View this thread: http://www.excelforum.com/showthread.php?threadid=49729