View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Preet Preet is offline
external usenet poster
 
Posts: 1
Default Displaying date/time!


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