How to I create a macro that opens every excel file in a

[mrissi]

directory then runs a nested macro, closes the file and opens the next file in the same directory.

I have the sub macro written and I have the close and save done; But I can't figure out how to open each file.

Any help would be appreciated!

Thanks!

 

[Tom Urtis]

mrissi --
"Must be nice to live in Southern California right now, Oakland, The Ducks and the Angels all in the respective finals.... I, being from Philadelphia, have not expirienced the joy of winning... anything.... at all... in the last 23 years...."

FYI, Oakland is in northern California. As I recall, the 76ers won it all in 1983, 20 years ago and got to the Finals 2 years ago. I also remember the Broad Street Bullies from the mid '70's.

Y'know what Nate, it's hard to be a Sharks fan...they have a way of snatching defeat from the jaws of victory (pun intended). I follow the Leafs; I grew up across Lake Ontario from Toronto.

And that's the sports wrap-up from the California news desk. Anyone see an Excel forum around here?