Richard,

there is an example at http://tinyurl.com/67tfh


--

HTH

RP

"wraithlead" wrote in message
...

I need to open a file, copy a few lines and close it. then open the
next. I know how to do all that except getting the loop to open the
next file automatically. The trouble is that i don't know how many
files might be in the folder. it might be 4 or 5, but it might be up to
10 or 11.

any suggestions?

thanks,
richard


--
wraithlead
------------------------------------------------------------------------
wraithlead's Profile:
http://www.excelforum.com/member.php...o&userid=11578
View this thread: http://www.excelforum.com/showthread...hreadid=272696