VBA's Equivalent of VBScript's SetLocale 
Author Message
 VBA's Equivalent of VBScript's SetLocale

Hi,

Does anyone know the VBA equivalents to the following VBScripting functions
:-

    SetLocale - Sets the global locale and returns the previous locale and,
    GetLocale  - Returns the current locale ID value.

I need to do the following in VBA

Sub Button1_onclick
  Dim original
  original = SetLocale("en-gb")
  mydate = CDate(UKDate.value)
  ' IE always sets the locale to US English so use the
  ' currentLocale variable to set the locale to US English
  original = SetLocale(currentLocale)
  USDate.value = FormatDateTime(mydate,vbShortDate)
End Sub

Thanks in Advance,
AO



Mon, 07 Mar 2005 21:45:24 GMT  
 VBA's Equivalent of VBScript's SetLocale
Hi,

Does anyone know the VBA equivalents to the following VBScripting functions
:-

    SetLocale - Sets the global locale and returns the previous locale and,
    GetLocale  - Returns the current locale ID value.

I need to do the following in VBA

Sub Button1_onclick
  Dim original
  original = SetLocale("en-gb")
  mydate = CDate(UKDate.value)
  ' IE always sets the locale to US English so use the
  ' currentLocale variable to set the locale to US English
  original = SetLocale(currentLocale)
  USDate.value = FormatDateTime(mydate,vbShortDate)
End Sub

Thanks in Advance,
AO



Mon, 07 Mar 2005 21:49:50 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VBA's Equivalent of VBScript's SetLocale

2. 'through account' VBA equivalent

3. JScript equivalent of VBScript 'Trim()'?

4. Equivalent to SetLocale ( VBSCript ) in JScript

5. VB equivalent of vbscript's EXECUTE method

6. Function equivalent to VBScript's Eval

7. VBA equivalent to GWBASIC's MKI$ ?

8. VB's equivalent voor VBA function: IsObjectValid

9. VBA equivalent to GWBASIC's MKI$ ?

10. JScript equivalent to 'Option Explicit'?

11. Postscript equivalent to UNIX 'cat' command

12. Equivalent of Vbscript's IsObject?

 

 
Powered by phpBB® Forum Software