Neutral date format in VBA

Hi,

I have an Excel macro that checks a document property which is a date. I am
checking a given date, which, if set, triggers a given processing. How can I
design my if statement so that the check is always working regardless of the
locale of the user running Excel, i.e. if I want to check if the date is
equal to the 15th of August 2005, how should my if statement look like ?

Thanks for help
Balex

if cdate(stringvariable) = DateValue("August 15, 2005") then

--
Regards,
Tom Ogilvy

"Balex" <Balex@discussions.microsoft.com> wrote in message
news:E91A0DA2-04E5-43E1-BA21-B06E55A0B794@microsoft.com...
> Hi,
>
> I have an Excel macro that checks a document property which is a date. I
am
> checking a given date, which, if set, triggers a given processing. How can
I
> design my if statement so that the check is always working regardless of
the
> locale of the user running Excel, i.e. if I want to check if the date is
> equal to the 15th of August 2005, how should my if statement look like ?
>
> Thanks for help
> Balex

Hi Balex

Try.....

Dim d as Date
d=DateSerial(2005,8,15)
If Date = d then
'Your Code here
End If


--

XL2003
Regards

William
willwest22@yahoo.com


"Balex" <Balex@discussions.microsoft.com> wrote in message
news:E91A0DA2-04E5-43E1-BA21-B06E55A0B794@microsoft.com...
> Hi,
>
> I have an Excel macro that checks a document property which is a date. I
> am
> checking a given date, which, if set, triggers a given processing. How can
> I
> design my if statement so that the check is always working regardless of
> the
> locale of the user running Excel, i.e. if I want to check if the date is
> equal to the 15th of August 2005, how should my if statement look like ?
>
> Thanks for help
> Balex

If CDate(mydatestring) = #2005-08-15# Then
...

--
HTH

Bob Phillips

"Balex" <Balex@discussions.microsoft.com> wrote in message
news:E91A0DA2-04E5-43E1-BA21-B06E55A0B794@microsoft.com...
> Hi,
>
> I have an Excel macro that checks a document property which is a date. I
am
> checking a given date, which, if set, triggers a given processing. How can
I
> design my if statement so that the check is always working regardless of
the
> locale of the user running Excel, i.e. if I want to check if the date is
> equal to the 15th of August 2005, how should my if statement look like ?
>
> Thanks for help
> Balex