Please bear with me I know that this has been talked about previously.
I am trying to write a macro that runs automatically every sunday and
then prints multiple worksheets to pdf. I am able to put the code in
that works without a specific file name but everytime I put a
destination filename in and try to open the file it says it is a
corrupted. These are weekly market files which will always be saved in
the same spot so I don't need to have a user pass a file name. Any help
is appreciated.

Thanks,


--
cooter24
------------------------------------------------------------------------
cooter24's Profile: http://www.excelforum.com/member.php...o&userid=29619
View this thread: http://www.excelforum.com/showthread...hreadid=537883