Results 1 to 20 of 30

Thread: Extracting Word form Data and exporting to Excel spreadsheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Hi

    I'm very new to this and have tried the code & get the same error.

    Compile error:
    User-defined type not defined

    I tried this solution "
    You need to 'enable' (excuse any misunderstanding there please!) the reference to the Word object from within the VBA window following Tools > References > Microsoft Word Object Library"

    But References is greyed out in my VBA tools menu, can some one help please?

    Thanks

    Chris

  2. #2
    VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Quote Originally Posted by Buccaneer66 View Post
    I tried this solution "You need to 'enable' (excuse any misunderstanding there please!) the reference to the Word object from within the VBA window following Tools > References > Microsoft Word Object Library"

    That 'solution' is nothing more than a re-hash of a comment in the macro itself:
    'Note: this code requires a reference to the Word object model
    But References is greyed out in my VBA tools menu, can some one help please?

    That will be because you haven't cleared the error. Click on Run>Reset, then set the reference.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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