which code for the SpellLang in English ?

  • Thread starter Thread starter François
  • Start date Start date
F

François

Hi,

I created an Excel file (XP/XL:2000) which is using the check spelling with
the code :
Range(Cells(19, 2), Cells(50, 9)).CheckSpelling SpellLang:=1033

I would like to know the valid number version for the SpellLang, according
to the US language

The number 1033 is actually valid for the french language of north America
....

François
 
I just ran a test using English and the Macro recording feature. It
spit this out:

ActiveCell.FormulaR1C1 = "spelling something wronge"
Range("J6").Select
Cells.CheckSpelling SpellLang:=1033

It would appear that 1033 is valid for US English as well.
 
Hello Mark,

There's something I don't understand, because on a computer wtih the french
system (keyboard and local setting and language are differents than US ones)
it works with 1033. I sent it to a american girl (living in Paris) who is
having a US computer using US setting , keyboard and language, and she
talled me that the checkspelling didn't work and the macro abort on the line
"Cells.CheckSpelling SpellLang:=1033"

So I don't know what's going on !

Here' my file : http://cjoint.com/?komdmCgUWS

François
 
I downloaded your file, but opened it with macros disabled.
Following is the code from the SpellMod module...
'---
Sub Correction_orthographe()
Range(Cells(19, 2), Cells(50, 9)).CheckSpelling SpellLang:=1001
Application.Goto Reference:=[A8], Scroll:=True
MsgBox ("Check spelling finished !")
End Sub
---
Note that the ID number used is 1001 not 1033 as you stated.
Besides correcting the language ID number I would also try out a version
that omits that parameter - XL97 for instance does not use SpellLang.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"François" <[email protected]>
wrote in message
Hello Mark,
There's something I don't understand, because on a computer wtih the french
system (keyboard and local setting and language are differents than US ones)
it works with 1033. I sent it to a american girl (living in Paris) who is
having a US computer using US setting , keyboard and language, and she
talled me that the checkspelling didn't work and the macro abort on the line
"Cells.CheckSpelling SpellLang:=1033"
So I don't know what's going on !
Here' my file : http://cjoint.com/?komdmCgUWS
François




"Mark"
a écrit dans le message de news:
 
I'm using Excel 2007 in the U.S. My computer language is English (U.S). I
recorded a spell check macro and got

Sub Macro1()
Cells.CheckSpelling SpellLang:=1033
End Sub

Tyro
 
Back
Top