Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to setup daily auto-save-as of a dynamic worksheet
I have a training matrix that I would like to setup to automatically save as
"current date" on a daily basis. All of the cells are "conditionally formatted", so the worksheet changes all the time. Instead of manually "Save As", I was wondering if there was a way to "auto save as" a new file every day at the same time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to setup daily auto-save-as of a dynamic worksheet
one option would be to use the "Scheduled Tasks" in your control pannel. you
can setup a bat file to execute that would copy this file at whatever time. I have linked this via excel to help name the file , but you could have a bat to just copy that file daily at 2pm "Turbine Mechanic" wrote: I have a training matrix that I would like to setup to automatically save as "current date" on a daily basis. All of the cells are "conditionally formatted", so the worksheet changes all the time. Instead of manually "Save As", I was wondering if there was a way to "auto save as" a new file every day at the same time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
how do i setup a table of daily income and expenses | Excel Worksheet Functions | |||
save page setup settings to transfer from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Auto-save worksheet on close? | Excel Discussion (Misc queries) |