Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.

I tried the code and excluded the AM/PM and it worked for me.


Cesar Zapata

"flawed" wrote in message
...
Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.

Hi

Not much experience with this so I choose for the left function

Try this

Dim Str As String
Str = Format(Now(), "YYYY MM DD HH MM SS AM/PM")
ActiveWorkbook.SaveAs Left(Str, Len(Str) - 3)


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"flawed" wrote in message ...
Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.

The hour is different Cesar (20 and 08)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Cesar Zapata" wrote in message ...
I tried the code and excluded the AM/PM and it worked for me.


Cesar Zapata

"flawed" wrote in message
...
Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.