Hi

Was wondering whether ANYONE can help!

I am importing some data from a csv file into an xls, by pressing
button (with macros behind it) - now what I am also looking to do i
for the time and date to display on the form, once every import is don
(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? Otherwis
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!

--
Pree
-----------------------------------------------------------------------
Preet's Profile: http://www.excelforum.com/member.php...nfo&userid=315
View this thread: http://www.excelforum.com/showthread.php?threadid=39381

"Preet" wrote in
message ...

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 YO
THANK YOU THANK YOU :) THANK YOU THANK YOU THANK YOU THANK YO

--
Pree
-----------------------------------------------------------------------
Preet's Profile: http://www.excelforum.com/member.php...nfo&userid=315
View this thread: http://www.excelforum.com/showthread.php?threadid=39381

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"
wrote in message
...

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


--
Preet
------------------------------------------------------------------------
Preet's Profile: http://www.excelforum.com/member.php...fo&userid=3155
View this thread: http://www.excelforum.com/showthread...hreadid=393818