FileSearch might do what you want. Here is a word macro that, starting with
an open file, finds the next file in the folder, closes the open one, and
opens the new one. It might have something you can adapt to what you want
to do. You can specify wildcards for the files to be found.

"systemx" wrote:


Hi there,

Just wandering if anyone can help me out. I'm looking for a method of
opening all text files in a folder.

I'm still pretty new to vba/macros - so not sure if this is possible. I
have tried googling and using the office vba help file to no avail.

It seems a filename is required when opening a document in excel using
vba. I have tried changing the filename to *.txt - which works but only
opens the first file then stops.

Would it be possible to use some sort of count function to open them
all?

Cheers

Rob


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=526961