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

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

--
Message posted from http://www.ExcelForum.com

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

ya
ya

recored yourself doing it and u got your macro :)

-----Original Message-----
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 lot


---
Message posted from http://www.ExcelForum.com/

.

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

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

--
Message posted from http://www.ExcelForum.com