Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Thanked 0 Times in 0 Posts

    Word VBA References (Word 2000)

    I am about to distribute a Word template nationally. The template relies heavily on VB to do stuff. I've noticed that on some machines the templates falls over because the appropriate references in 'Tools > References' aren't selected.

    How can I set them using VB so that when the template is used, all the correct references are selected?

    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Word VBA References (Word 2000)

    References are stored with a document/template, so if they don't work on a client's PC, there must be some kind of problem. Trying to set a reference in code may be a case of trying to pull yourself out of quicksand by your own hair.

    If you set a reference to the Microsoft Visual Basic for Applications Extensibility library, you can use the References collection and the Reference object in code. The References collection has methods AddFromFile and AddFromGuid that can be used to set a reference. For example to set a reference to the Access 2000 Object Library:

    Application.VBE.ActiveVBProject.References.AddFrom File "C:Program FilesMicrosoft OfficeOfficeMSACC.OLB"

    The problem, of course, is whether a particular library has been installed at all on the user's PC, and if so, where. Moreover, the user will have to allow programmatic access to the Visual Basic project - this is forbidden by default.

    You can check if a reference is invalid by checking its IsBroken property.

Posting Permissions

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