A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

vba or excel help



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 05:21 PM posted to microsoft.public.excel.misc
jcheko
external usenet poster
 
Posts: 37
Default 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  
Old April 9th, 2010, 05:53 PM posted to microsoft.public.excel.misc
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default 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  
Old April 9th, 2010, 06:20 PM posted to microsoft.public.excel.misc
jcheko
external usenet poster
 
Posts: 37
Default 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  
Old April 9th, 2010, 06:41 PM posted to microsoft.public.excel.misc
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default 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  
Old April 9th, 2010, 07:02 PM posted to microsoft.public.excel.misc
jcheko
external usenet poster
 
Posts: 37
Default 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  
Old April 9th, 2010, 07:10 PM posted to microsoft.public.excel.misc
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default 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  
Old April 9th, 2010, 11:44 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.