I've been given the task of making a spreadsheet that will make a copy
of itself, at the end of the day. I would like to have a button in my
spreadsheet that creates a back up copy and then exit. Can I get it to
check for (and maybe create) a folder called 'backup' (at the same
level as the original spreadsheet) and then save it there? I don't want
the user to get too involved in this process - apart from clicking the
'Backup and Exit' button.

Can anyone explain what I would have to do in order to do that? What
would I have to write in Visual Basic? Thanks for your co-operation..
:)


--
petros89
------------------------------------------------------------------------
petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645
View this thread: http://www.excelforum.com/showthread...hreadid=382319