View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicole Seibert Nicole Seibert is offline
external usenet poster
 
Posts: 60
Default Format(Time, "h.mm AM/PM") question

Here is the code:

'This is the name of the workbook with transferred data. This allows a
date/time stamp in the name.
wbname = "TERData " & Format(Date, "mm-dd-yyyy") & " " & Format(Time,
"h.mm AM/PM")

It stops on the word: TIME. why? This has worked for weeks and today it
stopped working. I can't see anything that I changed in this line that would
affect the outcome except I moved the code from a private open workbook macro
into my private stash to test the email functionality on select memebers of
my team.

Here is a section of my log that also captures date and time the same way.
You can see how the code use to work and now doesn't as the time switches to
12am and doesn't move forward:

TERData 42 7/5/2006 8:54:39 AM
TERData 43 7/5/2006 8:55:16 AM
TERData 44 7/5/2006 12:00:00 AM
TERData 45 7/5/2006 12:00:00 AM
TERData 46 7/5/2006 12:00:00 AM