importing a lot of text files to excel sheet at one go

[vikram]

hello

can we import a lot of text files in one excel sheet in one go?
can we have a macro for this

thanks a lo

 

[steve]

ya
ya

recored yourself doing it and u got your macro

 

[vikram]

the problem is that the name of the text file doesnt remain same

generally there is a text file for each day but sometimes we dont hav
text file on some days , if i will record a macro based on date an
during that month we dont have all the text file for a particular da
what will happen

i want a macro which asks the user whichfile to import next!

thanks for replyin