hi all
just wanted to aks if there is any kinda of auto- fucntion that can archive a worksheet separatly wihout needing to save the acctual file.
like i have "book1" and i add an entry then print the sheet but i dont want to save it cuz its a template-like but i want to have a record of it some where else with same date.
like "book1 05-10-2005", "book1 06-10-2005" and so on to be saved in given path(folder).

i know i can do this by "save-as" but then i must always give the file name over and over and i must choose where to save everytime.