Newbie - Unusual DATE question

  • Thread starter Thread starter Hosh
  • Start date Start date
H

Hosh

I have a spreadsheet that is little more than a list of PO #'s that shows
what orders are done and ready to ship for a particular customer.

We upload the file every day to a website where the customer can view it
whenever they want.

So far, everything's fine.

I use the "=TODAY()" function so that when I open and modify the listings,
the date gets automatically updated.


The problem is, when the customer accesses the file, the date also updates
on THEIR end and the file looks more current than it really is. Is there a
way to maybe lock in the date ONLY when I save the file and not when the
file opens?
Any help or OTHER suggestions would be so much appreciated.
Thanks!
 
I asked a similar question recently and was given this macro for the date
and time. I'm guessing you could change Now() to Today() and use the
appropriate date format..

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "mm/dd/yyyy h:mm AM/PM")
End Sub

I've assigned it to a keystroke and can now enter the current date and time
and get what I need.
 
Hosh
With your file open, right-click on the Excel icon that is immediately
to the left of the "File" in the menu across the top of the screen, select
"View code", and paste the following macro into the module that is on the
screen. Change "MySheet" to the name of the sheet you want, and change the
"A1" to the cell address where you want the date. Format that cell to
whatever date format you want. Note that the line that starts with
"Private" is one line all the way to "Boolean)". This macro will insert the
current date in the cell whenever you save the file.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheets("MySheet").Range("A1").Value = Date
End Sub
 
yeah, don't use Excel for this type of Activity.

You can do the same thing in Access; and you can PRINT a report-- or export
it to HTML or whatever you want to do..

and then you can have dumb reports

Excel sux; it is obsolete, it doesn't scale-- it isn't usable.

Aren't you tired of spaghetti code?
 
Back
Top