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