Mike,

Good stuff. God we're good, solutions and teaching, all in one package.

Can't quit laughing, or at least not smiling. And after all, there is more
to life than Excel and VBA.

Bob

"Full Monty " wrote in message
...
Bob,
LOL! I appreciate it! And guess what? I truly did learn something! I
actually figured both your methods out before I read your post!

Now don't laugh too hard but I figured them out by error and accident!
I used the ChDIR first but forgot to add the last "\" to the end of the
sub folder! That lerd me to your other option!

But I placed the pathway in the ActiveWorkbook line! It worked but
saved the file name as "sfilename"! So I tried in in the first line and
it worked like a charm!

I am learning! Albeit baby steps, but I am learning!

Thanks again! And quit laughing!

Mike


---
Message posted from http://www.ExcelForum.com/