I'm having a little problem with understanding what you try to do - you
code saves the Activeworkbook (!) into a specific location -
is the activeworkbook the database ?
do you just want to save the activeworrkbook into 2 different location
?

if yes than the user won't get the question to save the workbook, sinc
the workbook has already been saved and the - have a look at savecopya
...

cheers,
Gopp

--
Gopp
-----------------------------------------------------------------------
Goppi's Profile: http://www.excelforum.com/member.php...fo&userid=1582
View this thread: http://www.excelforum.com/showthread.php?threadid=27256