Repeat importing text
Hi, all,
Posts following Clayton's question regarding how to import text in VBA are
helpful but the code can only import one text file each time. I have a
folder which contains a number of log files which have uniform format. The
number of files vary from time to time. I want to import all of them in XL.
Can anybody give me a sample code to determine the number of file that meets
its importing critera in a folder and load them into one sheet of XL? Or
give me hint where to go?
Regards,
Huyeote
|