Importing multiple text files.

dzray · Mar 22nd, 2002, 10:23 AM

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 · Mar 22nd, 2002, 10:42 AM

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

"Way to many Spead Sheets"

http://www.mrexcel.com/board/viewtop...c=1428&forum=2

Regards
AJ

dzray · Mar 22nd, 2002, 02:20 PM

After a little tweaking, this looks good. Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 10:23 AM	#1
dzray New Member Join Date: Mar 2002 Posts: 2	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!

Mar 22nd, 2002, 10:42 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Have a look at a post I made earlier, may help... "Way to many Spead Sheets" http://www.mrexcel.com/board/viewtop...c=1428&forum=2 Regards AJ

Mar 22nd, 2002, 02:20 PM	#3
dzray New Member Join Date: Mar 2002 Posts: 2	After a little tweaking, this looks good. Thanks!