Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
I need to figure out a formula that returns the date when the spreadsheet was
last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
There's probably a really good way to do this.
How about this macro. It uses the shortcuts for date Ctrl ; and for time Ctrl/Shift ; Activates by Ctrl S and includes a save. So, whenever you want to save the changes enter Ctrl-S and the date and time will appear. Change cells to suit. Format cells appropriately. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+s ' Range("A1").Select ActiveCell.FormulaR1C1 = "4/9/2010" Range("A2").Select ActiveCell.FormulaR1C1 = "5:47:00 PM" Range("A3").Select ActiveWorkbook.Save End Sub -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
your macro does work and it will put the date and time you included in the
quotation signs that is cool, but it won't recognize if I modified the spreadsheet, all I am saying is that if between "range a5:s33" I changed something on it, the date should update, do you have another suggestion? thanks alot "Russell Dawson" wrote: There's probably a really good way to do this. How about this macro. It uses the shortcuts for date Ctrl ; and for time Ctrl/Shift ; Activates by Ctrl S and includes a save. So, whenever you want to save the changes enter Ctrl-S and the date and time will appear. Change cells to suit. Format cells appropriately. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+s ' Range("A1").Select ActiveCell.FormulaR1C1 = "4/9/2010" Range("A2").Select ActiveCell.FormulaR1C1 = "5:47:00 PM" Range("A3").Select ActiveWorkbook.Save End Sub -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
You might get what you want by searching the Help - input 2Track changes in a
shared workbook" I don't think yours is shared but it may help you. Good luck Cheers -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: your macro does work and it will put the date and time you included in the quotation signs that is cool, but it won't recognize if I modified the spreadsheet, all I am saying is that if between "range a5:s33" I changed something on it, the date should update, do you have another suggestion? thanks alot "Russell Dawson" wrote: There's probably a really good way to do this. How about this macro. It uses the shortcuts for date Ctrl ; and for time Ctrl/Shift ; Activates by Ctrl S and includes a save. So, whenever you want to save the changes enter Ctrl-S and the date and time will appear. Change cells to suit. Format cells appropriately. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+s ' Range("A1").Select ActiveCell.FormulaR1C1 = "4/9/2010" Range("A2").Select ActiveCell.FormulaR1C1 = "5:47:00 PM" Range("A3").Select ActiveWorkbook.Save End Sub -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
thanks for your help..for now I am going to use a button in my spreadheet
linked to your macro..it is working well....I will still have to figure it out on the changes for the spreadsheet though...but for your time...very much appreciated. "Russell Dawson" wrote: You might get what you want by searching the Help - input 2Track changes in a shared workbook" I don't think yours is shared but it may help you. Good luck Cheers -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: your macro does work and it will put the date and time you included in the quotation signs that is cool, but it won't recognize if I modified the spreadsheet, all I am saying is that if between "range a5:s33" I changed something on it, the date should update, do you have another suggestion? thanks alot "Russell Dawson" wrote: There's probably a really good way to do this. How about this macro. It uses the shortcuts for date Ctrl ; and for time Ctrl/Shift ; Activates by Ctrl S and includes a save. So, whenever you want to save the changes enter Ctrl-S and the date and time will appear. Change cells to suit. Format cells appropriately. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+s ' Range("A1").Select ActiveCell.FormulaR1C1 = "4/9/2010" Range("A2").Select ActiveCell.FormulaR1C1 = "5:47:00 PM" Range("A3").Select ActiveWorkbook.Save End Sub -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
You're welcome. Please tick Yes if I was helpful.
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: thanks for your help..for now I am going to use a button in my spreadheet linked to your macro..it is working well....I will still have to figure it out on the changes for the spreadsheet though...but for your time...very much appreciated. "Russell Dawson" wrote: You might get what you want by searching the Help - input 2Track changes in a shared workbook" I don't think yours is shared but it may help you. Good luck Cheers -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: your macro does work and it will put the date and time you included in the quotation signs that is cool, but it won't recognize if I modified the spreadsheet, all I am saying is that if between "range a5:s33" I changed something on it, the date should update, do you have another suggestion? thanks alot "Russell Dawson" wrote: There's probably a really good way to do this. How about this macro. It uses the shortcuts for date Ctrl ; and for time Ctrl/Shift ; Activates by Ctrl S and includes a save. So, whenever you want to save the changes enter Ctrl-S and the date and time will appear. Change cells to suit. Format cells appropriately. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+s ' Range("A1").Select ActiveCell.FormulaR1C1 = "4/9/2010" Range("A2").Select ActiveCell.FormulaR1C1 = "5:47:00 PM" Range("A3").Select ActiveWorkbook.Save End Sub -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "jcheko" wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba or excel help
Where do you want the modified date/time to be entered?
You can return that info to a cell or cells using event code. Do you want it immediate or when you save or?? Can be done easily and automatically without hitting a button. Tell us where you want the info displayed and when. Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 09:21:02 -0700, jcheko wrote: I need to figure out a formula that returns the date when the spreadsheet was last modified. any changes number, letter, symbol...if I make any change I need the formula to return back the date teh spreadsheet was last modified...any help....thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|