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

V

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
 
V

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
 
Top