Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time stamp macro to capture changes from one workbook to another
Hi Guys,
I'm totally stumped...Is there a way to have one workbook open and capture the time when another workbook is modified? Workbook A is for entering names and times of employees registering for a class, Workbook B is looking at the entries, and timestamping them, to capture who signed up first for that particular class first. Please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time stamp macro to capture changes from one workbook to another
This is not a complete answer...
Perhaps if Workbook A is somehow configured to activate a macro each time a name is entered. Perhaps the operator's procedure for using the sheet calls for activating a macro that first time stamps the result, and then performs the same function as enter. On the macro for Sheet A, you want it to do something line set sheetB.range(cell ( ), ABC ).value = now() set sheetB,Cell( ).value = Cell( ).value + 1 Where Cell( ) is the location storing the index. And ABC is the column that will hold the dates. YOu could also have it send across the name so you have both name and date. wrote: Hi Guys, I'm totally stumped...Is there a way to have one workbook open and capture the time when another workbook is modified? Workbook A is for entering names and times of employees registering for a class, Workbook B is looking at the entries, and timestamping them, to capture who signed up first for that particular class first. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Time stamp Help | Excel Worksheet Functions | |||
Insert Time Stamp when macro is run | Excel Discussion (Misc queries) | |||
Time Stamp for specific macro.. | Excel Programming | |||
Date/Time Stamp Macro Button Problem | Excel Programming | |||
Saving a time stamp with a macro? | Excel Programming |