Thread: Datevalue Error
View Single Post
  #3  
Old May 3rd 09, 07:45 PM posted to microsoft.public.outlook.program_vba
Pierre Scerri
external usenet poster
 
Posts: 23
Default Datevalue Error

Thanks. That was it.

"Michael Bauer [MVP - Outlook]" wrote:



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:

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


Ads