Paul - thanks for the tip, that worked.

now i just need to figure out why when i open the original file, the
name changes on me. i have 54 files and they all end with a date like
24Aug05. that's the part that changes on me. it must have something to
do with an auto naming from the original user?

i was poking around in the footer section and went to the section where
you could insert the &[File]. that's the part that's going to goof me up
unless i can somehow prevent it from renaming the file. thanks your help
and thanks for any insight.


--
gidget
------------------------------------------------------------------------
gidget's Profile: http://www.excelforum.com/member.php...o&userid=28460
View this thread: http://www.excelforum.com/showthread...hreadid=480604