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

Spellchecker language easy change



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 5th 06, 05:43 PM posted to microsoft.public.outlook.program_vba
Lorenzo
external usenet poster
 
Posts: 2
Default Spellchecker language easy change

Hi,

I've been searching with no success a working example ...
Does anybody has a sub or an example to change the spell check by code?
I should switch from 1033 and 1040 SpellLang.
I just want to add a button on Outlook toolbar that run a sub like this

Sub SwitchSpelling()
' this code does not work!
If LanguageSettings.LanguagePreferredForEditing = 1033 Then
set LanguageSettings.LanguagePreferredForEditing (1033)
Else
set LanguageSettings.LanguagePreferredForEditing (1040)
End If

End Sub

Ty for any help,

Lorenzo

  #2  
Old June 6th 06, 07:38 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Spellchecker language easy change

It doesn't work because that property is read-only.

You'll have to use the Win32 API (or Google "VB Registry Class") to change
the value of this registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Options\Spelling\SĀ*peller

If you try various language selections in the Options dialog and click
Apply, you'll see the relevant values get inserted into that key if you
refresh regedit.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Lorenzo" wrote:

Hi,

I've been searching with no success a working example ...
Does anybody has a sub or an example to change the spell check by code?
I should switch from 1033 and 1040 SpellLang.
I just want to add a button on Outlook toolbar that run a sub like this

Sub SwitchSpelling()
' this code does not work!
If LanguageSettings.LanguagePreferredForEditing = 1033 Then
set LanguageSettings.LanguagePreferredForEditing (1033)
Else
set LanguageSettings.LanguagePreferredForEditing (1040)
End If

End Sub

Ty for any help,

Lorenzo


  #3  
Old June 9th 06, 10:42 AM posted to microsoft.public.outlook.program_vba
Lorenzo
external usenet poster
 
Posts: 2
Default Spellchecker language easy change

Ty Eric,
it would be great if you could provide me an example of code to change
the value the registry.
I've never used the Win32 API in a VBA module :-(

Lorenzo

Eric wrote:
It doesn't work because that property is read-only.

You'll have to use the Win32 API (or Google "VB Registry Class") to change
the value of this registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Options\Spelling\S*peller

If you try various language selections in the Options dialog and click
Apply, you'll see the relevant values get inserted into that key if you
refresh regedit.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Lorenzo" wrote:

Hi,

I've been searching with no success a working example ...
Does anybody has a sub or an example to change the spell check by code?
I should switch from 1033 and 1040 SpellLang.
I just want to add a button on Outlook toolbar that run a sub like this

Sub SwitchSpelling()
' this code does not work!
If LanguageSettings.LanguagePreferredForEditing = 1033 Then
set LanguageSettings.LanguagePreferredForEditing (1033)
Else
set LanguageSettings.LanguagePreferredForEditing (1040)
End If

End Sub

Ty for any help,

Lorenzo



  #4  
Old June 9th 06, 04:09 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Spellchecker language easy change

Download this component:

vbAccelerator - Complete Registry control:
http://www.vbaccelerator.com/home/VB...ol/article.asp

It will make working with the registry a lot easier, without needing to use
the Win32 API.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Lorenzo" wrote:

Ty Eric,
it would be great if you could provide me an example of code to change
the value the registry.
I've never used the Win32 API in a VBA module :-(

Lorenzo

Eric wrote:
It doesn't work because that property is read-only.

You'll have to use the Win32 API (or Google "VB Registry Class") to change
the value of this registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Options\Spelling\SĀ*peller

If you try various language selections in the Options dialog and click
Apply, you'll see the relevant values get inserted into that key if you
refresh regedit.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Lorenzo" wrote:

Hi,

I've been searching with no success a working example ...
Does anybody has a sub or an example to change the spell check by code?
I should switch from 1033 and 1040 SpellLang.
I just want to add a button on Outlook toolbar that run a sub like this

Sub SwitchSpelling()
' this code does not work!
If LanguageSettings.LanguagePreferredForEditing = 1033 Then
set LanguageSettings.LanguagePreferredForEditing (1033)
Else
set LanguageSettings.LanguagePreferredForEditing (1040)
End If

End Sub

Ty for any help,

Lorenzo




 




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
Spellchecker language easy change banjo Outlook and VBA 2 April 21st 06 07:25 AM
Spellchecker... me Outlook Express 1 April 10th 06 11:21 PM
change language btissam Outlook - Using Contacts 1 March 6th 06 11:40 AM
Easy question -hard answer AJR Outlook - General Queries 1 January 31st 06 09:07 PM
Easy question - hard answer? John Wright Outlook - General Queries 4 January 31st 06 08:57 PM


All times are GMT +1. The time now is 10:26 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.