A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Datevalue Error



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 2nd 09, 03:52 PM posted to microsoft.public.outlook.program_vba
Pierre Scerri
external usenet poster
 
Posts: 23
Default Datevalue Error

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
  #2  
Old May 2nd 09, 05:58 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Datevalue Error



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

  #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


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error MSG No, Socket Error: 10060, Error Number: 0x800CCC0E Skippy Outlook - Installation 1 December 13th 08 03:26 PM
Error 25090 - Office Source Engine, system error 2147024893 jcswarriorprincess Outlook - Installation 6 November 30th 08 12:12 AM
Redemption insert text - Run-time error '-2147467259 (80004005)' Unspecified Error JW Outlook and VBA 16 December 22nd 07 10:26 PM
error prtocol smpt, port 25, no socket error,10061, nr 0x8ooCCC0e Larry W StJohn Outlook - General Queries 6 August 16th 06 02:39 PM
Outlook 2003 Calendar Error-CAN'T OPEN THIS ITEM. UNKNOWN ERROR Bluze Outlook - Calandaring 4 June 14th 06 04:35 AM


All times are GMT +1. The time now is 04:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.