Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating time made by macro in excel
I have recorded a macro in excel. The macro includes current date and current
time which are pasted into two separate cells. I use ctrl+; and ctrl+: when programming the macro. When using the macro, the values of both date and time are constantly the same as the date and time I made the macro. How may the date and time be changed to the actual time when I use the macro? Using the now() - function is not much help, as then all macros recorded change to the actual date and time. I used the program recorder.exe, and old -93-version earlier - but it does not work with Vista. Thankful if anyone can help me out here. -- hjemmehososs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help ( Hope i made it clear this time) | Excel Worksheet Functions | |||
auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME | Excel Programming |