How to archive an entire spreadsheet?

**rarin** · 08-28-2007, 08:11 AM

Just wondering how you would do this in excel?

Must you use a macro?

And if you do what are the steps required to create a macro for archiving?

Ty in advance for any replies.

**arthurbr** · 08-28-2007, 08:14 AM

Welcome to the board

What do you actually mean by " archiving"?

**rarin** · 08-28-2007, 08:48 AM

Well by archiving, I mean i want all the data and information in the excel spreadsheet to be backed up and archived. As in, a button or function in the spreadsheet which allows a user to create a copy of the spreadsheet in another location. Say C:/Temp.

Edit: Thanks for your welcome