Good day guys!

Can you please help me on this?


Here are the parts of my project and its code.

My project is to consolidate data from text file(.txt)
*note that i can select multiple text file, in which 1 text file = 1 sheet
*What is happening is that it is opening a new workbook
*How can I make it open to just the same workbook but just different sheet

Here is my code for that part:
Please Login or Register  to view this content.

And then delete rows that has blank in selected columns.
*can I make an excemption and choose only 2 columns?
*also note that different text files also has different number of columns.

Here is my code for the deletion part of rows part
Please Login or Register  to view this content.
Can you pleas help me combine this two codes and make it that after consolidation, rows with blank are already deleted. Thank you
I've already tried different techniques but still to no avail.
New set of codes will be highly appreciated if it is for the best.