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

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

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

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

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

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

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