MACRO ACTIVATED AUTOMATICALLY

[Spiros]

Hi to everyone

I have one file with 3 pages. The 3 pages have the same content. I want to
create a macro which automatically one time every day (when the day changes)
will delete certain cells (for example: C10, C11, C12) in each page.
Also this macro will add the number:1 in certain cells (for example: D10,
D11, D12) in each page.
NOTICE: The above macro will be activated automatically (when the file
opened) one time a day (when the day changes).
Thanks in advance.

Spiros

 

[Nayab]

Hi to everyone

I have one file with 3 pages. The 3 pages have the same content. I want to
create a macro which automatically one time every day (when the day changes)
will delete certain cells (for example: C10, C11, C12) in each page.
Also this macro will add the number:1 in certain cells (for example: D10,
D11, D12) in each page.
NOTICE: The above macro will be activated automatically (when the file
opened) one time a day (when the day changes).
Thanks in advance.

Spiros

well to make the macro run automatically when the file is opened, u
can call this macro from the Auto_open macro.
To make it run once a day, u need to write the date each time this
macro runs. Say u write the date in E1. Then every time the macro is
called u can check if the value in E1 is less than today's date or
not. If it is so, then u can proceed with the processing else exit
sub. In case u want to read abt Autpen read here:
http://office.microsoft.com/en-us/excel/HA010346281033.aspx