Results 1 to 3 of 3

Thread: Dim (Word 2007)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dim (Word 2007)

    This statement is from a Word 2003 macro: "Dim XlApp As Excel.Application". It doesn't work in Word 2007. Can anyone tell me why and what it should say?

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

    Re: Dim (Word 2007)

    In the Visual Basic Editor, select Tools | References... (if that still works in Office 2007).
    Locate Microsoft Excel 12.0 Object Library in the list of available references.
    Make sure that its check box is ticked, then click OK.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dim (Word 2007)

    Thanks Hans that worked!

Posting Permissions

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