Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Add Dictionary.com to Excel and PPT (XP)

    StuartR created this macro for me in the Word forum to add Dictionary website to my Word documents. (See thread 638,191).
    This works GREAT and exceeds my expectations.

    Sub CheckDictionary()

    Const strStem As String = "http://dictionary.reference.com/browse/"

    If Selection.Words.Count = 1 Then
    ActiveDocument.FollowHyperlink Address:=strStem & Selection.Words(1).Text, NewWindow:=True
    End If

    End Sub


    This would also be helpful in Excel and PPT if possible. Can the macro be adapted to these programs?

    Any help would be appreciated.

    Also how do you show the above thread as a link? Have not done that one yet.
    Richard Spring

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Add Dictionary.com to Excel and PPT (XP)

    I don't know the Excel and PowerPoint object models well enough to produce a version of this code that will give the same simple right click access to dictionary.com, but I do know how to make a link active in the lounge.

    To link to Post 638,191, you copy the post number from the top of the post (it looks like this <code><!t>[Post: 638,191]<!/t></code> ) and you paste it into your reply, the lounge will then format it as <post:=638,191>post 638,191</post:> .

    StuartR

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Dictionary.com to Excel and PPT (XP)

    In PowerPoint, you can use a macro like this:

    Sub CheckDictionary()
    Const strStem As String = "http://dictionary.reference.com/browse/"
    If ActiveWindow.Selection.TextRange.Words.Count = 1 Then
    ActivePresentation.FollowHyperlink Address:=strStem & _
    ActiveWindow.Selection.TextRange.Words(1).Text, NewWindow:=True
    End If
    End Sub

    See Customizing PowerPoint's right-click popup menus and Create an ADD-IN with TOOLBARS that run macros (you will need to create an add-in if you want to make a macro available in all presentations).

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Dictionary.com to Excel and PPT (XP)

    In Excel, it is difficult. As long as the user is editing a cell (for example to select a word), you can't run macros. So it is not really possible to use this method to check a single word.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Add Dictionary.com to Excel and PPT (XP)

    Thanks StuartR and HansV:

    Well two out of three is not bad. Pretty good odds even for Las Vegas.

    I have Word setup and am working on PPT.
    In Excel, if need be, I can copy and paste to Word for a definition.
    Richard Spring

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •