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

You could try something like this, petros:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=456
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"petros89" wrote in
message ...

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

Here is some code

With ActiveWorkbook
On Error Resume Next
MkDir .Path & "\backup"
On Error GoTo 0
.SaveCopyAs .Path & "\backup\" & .Name
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)


"petros89" wrote in
message ...

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

Yes, well it's close enough. Thanks for the help! :

--
petros8
-----------------------------------------------------------------------
petros89's Profile: http://www.excelforum.com/member.php...fo&userid=2464
View this thread: http://www.excelforum.com/showthread.php?threadid=38231