Importing multiple text files.

[dzray]

I have a series of text files that I would like to import on a daily basis into a workbook. Using VBA, I can set this up with a static filename, but the filename contains the current date, and when I attempt to open multiple files using wildcards, only the first one will open. (I'm not even sure the wildcard approach is the correct one):

Workbooks.OpenText FileName:="C:Loc*.loc",

Is there a loop I can set up that would handle this? I'm sure there is, but my skills in VBA are a little too meager.

In addition I'd like the source files to be deleted after they are imported.

Thanks all!

 

[AJ]

Have a look at a post I made earlier, may help...

"Way to many Spead Sheets"

http://www.mrexcel.com/board/viewtopic.php?topic=1428&forum=2

Regards
AJ

 

[dzray]

After a little tweaking, this looks good. Thanks!