Datevalue Error

  • Thread starter Thread starter Pierre Scerri
  • Start date Start date
P

Pierre Scerri

Hi

This line of code:

a=Datevalue("01 MAY 09")

is giving me a Type Mismatch error.

It was working before I re-installed Windows XP and Office 2003.

I have XP and Office SP3 as before. The refences in the VBA editor seem to
be all there.

Am I missing something?

Thanks

Pierre Scerri
 
I think that depends on your language setting. For me the German term works,
the English one doesn't.


--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 2 May 2009 07:52:01 -0700 schrieb Pierre Scerri:
 
Thanks. That was it.

Michael Bauer said:
I think that depends on your language setting. For me the German term works,
the English one doesn't.


--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 2 May 2009 07:52:01 -0700 schrieb Pierre Scerri:
Click to expand...
 
Back
Top