Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get autodate to stay the date it was saved
I use the formula =TODAY() often. But I want to know what to use when I want
to autodate today then when I go back into the worksheet tomorrow I want it show yesterday's date not todays. Does that make any sense, lol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get autodate to stay the date it was saved
Well..., consider the following suggestions in order to avoid the need for
VBA Macros. 1) Press: CTRL+; [CTRL+semicolon] to insert todays Date as TEXT. 2) If the cell already uses has the NOW() or TODAY() function - select that cell press [F9] and then [Enter]. Micky "totally lost" wrote: I use the formula =TODAY() often. But I want to know what to use when I want to autodate today then when I go back into the worksheet tomorrow I want it show yesterday's date not todays. Does that make any sense, lol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get autodate to stay the date it was saved
If I have to use the vba macro, I would rather do that. here is the macro
already in use, what would I have to add to this: Public Sub SaveAsE5() Dim ThisFile As String Dim myPath As String myPath = "S:\louis\refurb log" If Right(myPath, 1) < "\" Then myPath = myPath & "\" End If ThisFile = ActiveSheet.Range("E5").Value ActiveWorkbook.SaveAs Filename:=myPath & ThisFile ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True "מיכאל (מיקי) אבידן" wrote: Well..., consider the following suggestions in order to avoid the need for VBA Macros. 1) Press: CTRL+; [CTRL+semicolon] to insert todays Date as TEXT. 2) If the cell already uses has the NOW() or TODAY() function - select that cell press [F9] and then [Enter]. Micky "totally lost" wrote: I use the formula =TODAY() often. But I want to know what to use when I want to autodate today then when I go back into the worksheet tomorrow I want it show yesterday's date not todays. Does that make any sense, lol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get autodate to stay the date it was saved
Maybe...
Public Sub SaveAsE5() Dim ThisFile As String Dim myPath As String myPath = "S:\louis\refurb log" If Right(myPath, 1) < "\" Then myPath = myPath & "\" End If with Activesheet.range("A1") .numberformat = "mmmm dd, yyyy" .value = date - 1 end with ThisFile = ActiveSheet.Range("E5").Value ActiveWorkbook.SaveAs Filename:=myPath & ThisFile ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True End sub I didn't know what worksheet to use or what cell to use. So I used A1 of the activesheet. And I wasn't sure if the code should be done before the save or after the save. You may want to move it. totally lost wrote: If I have to use the vba macro, I would rather do that. here is the macro already in use, what would I have to add to this: Public Sub SaveAsE5() Dim ThisFile As String Dim myPath As String myPath = "S:\louis\refurb log" If Right(myPath, 1) < "\" Then myPath = myPath & "\" End If ThisFile = ActiveSheet.Range("E5").Value ActiveWorkbook.SaveAs Filename:=myPath & ThisFile ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True "מיכאל (מיקי) אבידן" wrote: Well..., consider the following suggestions in order to avoid the need for VBA Macros. 1) Press: CTRL+; [CTRL+semicolon] to insert todays Date as TEXT. 2) If the cell already uses has the NOW() or TODAY() function - select that cell press [F9] and then [Enter]. Micky "totally lost" wrote: I use the formula =TODAY() often. But I want to know what to use when I want to autodate today then when I go back into the worksheet tomorrow I want it show yesterday's date not todays. Does that make any sense, lol -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use Today's date in a cell and make it stay the same date | Excel Discussion (Misc queries) | |||
what did I do to get autodate? | Excel Discussion (Misc queries) | |||
Autodate worksheet tab | Excel Discussion (Misc queries) | |||
Inserting an AutoDate Function | New Users to Excel | |||
TODAY() and stay that date.. | Excel Worksheet Functions |