"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")