hay any one help me in opening an existing txt files with a macro or
VBA coding.

like i have differrent txt files in differrent file if open those file
each txt file will be opened in one excel but i want all of them to be
opened in the same excel file but in differrent sheets.

and one more thing if we open a text file in excel it will ask us for
the coulumn and row breaks i want to skip that as my default delimitar
is a space

thank you