excel vba to insert files in worksheet

Hi All,

Good Day!!

Since I am new in this forum and this is my first post and I am also new in excel vba field. I am seeking one help which is related to excel vba loop. here is the step which I am looking for.

1) I have more than 50 different text files with different name in a folder.
2) I need help to insert the files into worksheets one by one meaning after the first text file's content will be inserted into the first worksheet it will copy the text files content and paste into the summary sheet and the first worksheet will be deleted automatically and again new worksheet will be added and the second text file will be inserted and will copy the text files content in the summary sheet's next row and it will go on as many as text files have into the folder.

Any help will be appreciable. Thank you.

Regards,
Pinaki

Yes these text files will be opened with excel and in the worksheets.

Thank you Davesexcel for the code. Here in this code all the text files contents are coming to a singe sheet. It worked properly but can the code be slight change? I mean the first text file will insert in a worksheet and copy the content to the master worksheet then that worksheet will be deleted and again the second text file will be inserted in a worksheet and copy the content to the master worksheet and similarly this will happen with other text files also.

Because I have so many .txt files and finally I have to prepare one report in .html format. so in that process as I mentioned above it will be easy to prepare the report and every .txt files are having more or less having same content I mean I have one batch script through which I collect some registry values of almost 100 computers and with those text files I need to prepare report. Thank you.

yes correct but I want when the first text file is inserted in the first worksheet it will copy the contents to master sheet and deletes that worksheet and this should happen in similar way with all the text files.

For more clarity.. Sheet 1 will be the master sheet, in sheet 2 the first text file will be inserted and the text file contents will be copy in Sheet 1 first row then sheet 2 will be deleted, again sheet 3 will be add and insert the next text file and copy the text files content to Sheet 1 second row and similarly it will go on for other files also.

Actually that procedure will help me to show in the report row wise and that is the reason I was asking the same. Thank you.

That's perfect as per expectation. Thank you so much Davesexcel..