Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering and displaying time | Excel Discussion (Misc queries) | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Displaying time from 00:00 to 0.00 | New Users to Excel | |||
Displaying Unix time as date and time | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |