Indeed, its doable, question is have you absolutely thought everything out -
you say you want to delete all information in the workbook after it's saved -
are you sure about that? Or are there column headers, info text, formulas,
etc that need to be left in place?
Also, you'd probably want to rename the workbook a second time after having
saved it with the data, because it's going to keep that name and if someone
comes along and saves it, then the original data saved is gone.

If this is a totally automated thing, look into setting up a perpetual loop
inside of either the Workbook_Open() or Worksheet_Activate() events to simply
check the time and when it is at (or after, hard to hit an exact time) then
do the rename, save, cleanup, and rename again functions. Probably only want
to set your timer for about every 10 or 20 minutes within the function to
keep from stealing too much time from the primary purpose of the workbook.

"mikespeck" wrote:


Hi,
I'm looking to rename and save my workbook to a destination file
everday at a preset time. After it saves to the destination file i need
all the data to be removed from the origional workbook.

Lets say I'm working with a workbook called Book1 everyday at lets say
3:00 p.m. it saves that Workbook to a destination file along with
todays date. Example Book1_8_21_06. Then once saved all data is
removed from the origional workbook.

Is this acheivable?

Mike


--
mikespeck
------------------------------------------------------------------------
mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946
View this thread: http://www.excelforum.com/showthread...hreadid=573762