| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Date Macro/Function
Hey everyone. I know most of the basic stuff about Excel, but I have never used Macros before and I believe that is what I need for this particular problem. What I need is some way that I can run a macro or whatever, and if I run the macro it will update a field on the spreadsheet. But I don't want it to update every time the user opens the spreadsheet, only if they run the macro. What I want the macro to display is the Year Month Day Hour Minute Second of whatever date/time it is when the macro is ran. And I need all of the values to be 2 digits. So if it was 2:33.54am January 1, 1994 and I ran the macro the field would be updated and say: 940101023354 formatted yymmddhhmmss If anyone knows how to do this I would greatly appreciate some instruction. Thanks very much in advance. Ryan M. Murphy -- RyanMMurphy ------------------------------------------------------------------------ RyanMMurphy's Profile: http://www.excelforum.com/member.php...o&userid=33453 View this thread: http://www.excelforum.com/showthread...hreadid=532608 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a macro or excel function copy a value on date | Excel Worksheet Functions | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
Threaded Mode
