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!
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!