Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / December 2004

Tip: Looking for answers? Try searching our database.

Date functions in VBA (English/Spanish)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roderick O'Regan - 15 Dec 2004 10:26 GMT
I'm trying to create a template in Word which is normally used with
the English version of Word.

One of the forms has a combobox which sets out the current month using
the following code:
   cmbIssueMonth.Value = Format(Date, "mmmm")

The problem arises when colleagues in Spain open the same template and
tell me they get an error which leads back to the piece of coding
above.

Is there something I could write, please, which could act as a
"catch-all" code and put the month name in the combobox corresponding
to the language version of Word they may be using? Or is VBA all the
same as regards dates in any language?

I hope it doesn't muddy the waters too much but the permutations of
machines being used in the Spanish office is interesting:
Spanish Windows - Spanish Word
Spanish Windows - English Word
English Windows - Spanish Word
English Windows - English Word

However, I appreciate that the above list might have no effect on what
I'm trying to do. It's the basic statement which could need amending.
Helmut Weber - 15 Dec 2004 17:10 GMT
Hi Roderick,
maybe this can help you:

MsgBox Application.Language
MsgBox System.LanguageDesignation

Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/
Roderick O'Regan - 16 Dec 2004 00:11 GMT
Thanks Weber. I think I can use this.

Regards

Roderick O'Regan

>Hi Roderick,
>maybe this can help you:
[quoted text clipped - 7 lines]
>Word XP, Win 98
>http://word.mvps.org/
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.