?
Solved

Spell Check in VB6

Posted on 2016-11-25
13
Medium Priority
?
208 Views
Last Modified: 2016-11-29
I need to spell check a VB6 text box. I asked this question here. Was directed to:
https://www.experts-exchange.com/articles/8678/Spell-check-a-VBA-or-VB6-ActiveX-textbox.html
Or:
http://tinyurl.com/ha7heas

I wrote a little test app. Just a text box and a command button. Compiled to an exe. The spell check exe works fine in XP. In Win7, nothing happens. No error. Nothing.

I can't debug in Win7 obviously.

Would it be convenient if I copied the source code from the above link here?
0
Comment
Question by:NormaPosy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
  • +2
13 Comments
 
LVL 29

Expert Comment

by:Pawan Kumar
ID: 41902061
The best way here is talk to the author.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41902102
Sorry but since I still use XP I won't be able to help find out what's wrong when run in Win 7. You may however find techniques in this article of mine on debugging that will help find the problem.
0
 

Author Comment

by:NormaPosy
ID: 41902119
Martin: VB6 won't run under Win7. At least that is what I have been told. Never tried it. (That's a lot of CDs to load just to find out.) There's a technique I have used to get around this. Back in XP, Define an error integer iErr. Sprinkle "Err = 1" (2, 3, 4, etc) throughout the code. Just before exiting, display a MsgBox showing iErr. At least that will tell me how far the thing got.

Thing is, under Win7 it doesn't throw up any errors. It just doesn't do anything.

The code invokes Word's spell checker. It first determines the resident version of Word. I am thinking that the "Cases" in the code don't include versions past when the code was created. I will look at that. There should be an "Else" I can use to tell me "Word not found". Or something like that.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 49

Accepted Solution

by:
Martin Liss earned 1000 total points
ID: 41902404
VB6 won't run under Win7
Isn't that what you are using?

I am thinking that the "Cases" in the code don't include versions past when the code was created.
Note line 8 to 10 from the current code.
    Select Case objWord.version
        'Office 2000 and later
        Case "9.0", "10.0", "11.0", "14.0"
            Set objDoc = objWord.Documents.Add(, , 1, True)
        'Office 97
        Case "8.0"
            Set objDoc = objWord.Documents.Add
        Case "Else"
            MsgBox "Sorry but your version of Word seems to be " & QUOTE & objWord.version _
                   & QUOTE & " and that version is not currently supported.", vbOKOnly + vbExclamation, "Spelling Checker"
            Exit Sub
    End Select

Open in new window

0
 

Author Comment

by:NormaPosy
ID: 41902554
Martin: I develop and compile on an XP machine. The exe runs fine there. On a Win7 machine, when I run the exe, nothing at all happens. No message box, no error report, nothing.

Yes, I think my version of Word is not included in those lines of code. But I don't get that message box under line 9 either. I will have to investigate and get back here.
0
 
LVL 8

Assisted Solution

by:Bob Hoffman
Bob Hoffman earned 500 total points
ID: 41903122
I have a similar solution working fine on Win7 and Win 10. Couple things to check.

>> is the spell check pop-up behind your main form?
>> open the task manager, is word running?
>> try turning off UAC


here's my function:

Public Function SpellCheck(strText As String) As String

    Dim oWord As Word.Application
    Dim oTmpDoc As Word.Document
   
    Screen.MousePointer = vbHourglass
    On Error GoTo Failed
    Err.Clear
   
    'Create a Word document object...
    App.OleRequestPendingTimeout = 999999
    Set oWord = CreateObject("Word.Application")
    oWord.Visible = False
   
    Set oTmpDoc = oWord.Documents.Add(, , 1, True)

    Screen.MousePointer = vbDefault
   
    'Assign the text to the document and check spelling.
    With oTmpDoc
        .Content.Text = Trim$(strText)
        .Activate
        oWord.Visible = False
       
        'Bring spell check forward
        Dim lngHandle As Long
        lngHandle = FindWindow(vbEmpty, "Document1 - MIcrosoft Word")
        If lngHandle <> 0 Then
            Dim lngRet As Long
            lngRet = BringWindowToTop(lngHandle)
        End If
       
        .CheckSpelling
        oWord.Visible = False
       
        'After user has made changes, get text back...
        SpellCheck = Left(.Content.Text, Len(.Content.Text) - 1)

        'Close the document and exit Word...
        oWord.Visible = False
        .Close False '= wdDoNotSaveChanges
    End With
   
    'Clean up
    Set oTmpDoc = Nothing
    oWord.Visible = False
    oWord.Application.Quit (False)
    Set oWord = Nothing

    Exit Function
Failed:
    Set oTmpDoc = Nothing
    Set oWord = Nothing
    Screen.MousePointer = vbDefault

    MsgBox "SpellCheck() failed! Error is: " & Trim$(Err.Description), vbCritical, "Critical error"
End Function
0
 
LVL 9

Assisted Solution

by:Karen
Karen earned 500 total points
ID: 41903409
If you have not already, you should change
 Case "Else"
to
 Case Else
1
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41903412
If you have not already, you should change
 Case "Else"
to
 Case Else
OMG, I never, and no one else as far as I know, has ever noticed that mistake!! I will update my article now. Thank you.
0
 
LVL 9

Expert Comment

by:Karen
ID: 41903446
dontcha hate bugs like that, Martin... when you notice them and think, "how the heck have I not noticed that before????" :D
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41903451
I know. In my case I can chalk it up to a "senior moment" but the article was first published 5 years ago and it has gotten lots of views and likes since then and nobody has said a word.
0
 

Author Closing Comment

by:NormaPosy
ID: 41904875
My version of word is "15.0". Had to add it to the case statement.

How many times have I stared buggy eyed at code not seeing the screw up. Then you call another set of eyeballs over and  "pop" - there it is. "Else" indeed!!

Thank you to everyone.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41904878
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
0
 
LVL 9

Expert Comment

by:Karen
ID: 41906600
I'm glad my eyeballs could be of assistance 8-)
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month11 days, 1 hour left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question