John, thank you very much for the speedy response. You made me realize
I'm referring to the workbook name instead of the worksheet name. I
fixed that issue only to find that Adobe's distiller doesn't like the
spaces in my folder names. To save headaches I think I'll just set the
files to save to c:\ and then just put a function in the macro to move
the files to the specified folders.

Thanks again!


--
Iwant2learn
------------------------------------------------------------------------
Iwant2learn's Profile: http://www.excelforum.com/member.php...o&userid=33461
View this thread: http://www.excelforum.com/showthread...hreadid=532644