Displaying date/time!

Hi

Was wondering whether ANYONE can help!

I am importing some data from a csv file into an xls, by pressing a button (with macros behind it) - now what I am also looking to do is for the time and date to display on the form, once every import is done (through button click).

2 questions:

1) How do I get the macro to locate current system date?

2) How do I specify where I want the date to be located? Otherwise where would it locate the date on the spreadsheet?

Ive tried this:

Dim Today
Today = Now

But it didnt help! :- (

Thank you for looking at this! x

"Preet" <Preet.1tfzud_1123499125.3994@excelforum-nospam.com> wrote in
message news:Preet.1tfzud_1123499125.3994@excelforum-nospam.com...
>
> Hi
>
> Was wondering whether ANYONE can help!
>
> I am importing some data from a csv file into an xls, by pressing a
> button (with macros behind it) - now what I am also looking to do is
> for the time and date to display on the form, once every import is done
> (through button click).
>
> 2 questions:
>
> 1) How do I get the macro to locate current system date?

That is Date

> 2) How do I specify where I want the date to be located? Otherwise
> where would it locate the date on the spreadsheet?

Range("A1").Value = Format(Date,"dd mmm yyyy")

THANK YOU David!

That worked - BUT! How do I get time displayed? (excluding seconds)

THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU

Preet,

'Now' returns both the date and time, so you can use the Format
function to return a date/time string in any format you want.
E.g.,

Range("A1").Value = Format(Now, "mm/dd/yyyy hh:mm")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Preet" <Preet.1tg86m_1123509982.4596@excelforum-nospam.com>
wrote in message
news:Preet.1tg86m_1123509982.4596@excelforum-nospam.com...
>
> THANK YOU David!
>
> That worked - BUT! How do I get time displayed? (excluding
> seconds)
>
> THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU
> THANK YOU
> THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU
>
>
> --
> Preet
> ------------------------------------------------------------------------
> Preet's Profile:
> http://www.excelforum.com/member.php...fo&userid=3155
> View this thread:
> http://www.excelforum.com/showthread...hreadid=393818
>

Hi Chris

Thank you for ur reply, that worked!

Very Grateful.

Preet x