I need to get the current day in a Macro, How could I do this!!!
I need to compare it with the Day in my OutLook Calendar.

--
Message posted from http://www.ExcelForum.com

You can use Date, like this:

Dim MyDate as Date

MyDate = Date


-----Original Message-----
I need to get the current day in a Macro, How could I do
this!!!
I need to compare it with the Day in my OutLook Calendar..


---
Message posted from http://www.ExcelForum.com/

.

If you want the day name, try

Format(date,"ddd")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tod" wrote in message
...
You can use Date, like this:

Dim MyDate as Date

MyDate = Date


-----Original Message-----
I need to get the current day in a Macro, How could I do
this!!!
I need to compare it with the Day in my OutLook Calendar..


---
Message posted from http://www.ExcelForum.com/

.

Dim MyDate
MyDate = Date

or to include time too

mydatetime = now()

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help


"alihussain19 " wrote in
message ...
I need to get the current day in a Macro, How could I do this!!!
I need to compare it with the Day in my OutLook Calendar..


---
Message posted from http://www.ExcelForum.com/