Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    name of VBProject (2002 SP2)

    Is it possible to read the host VB project name in Access VBA?

    In Excel this is done using ThisWorkbook.VBProject.Name but I can't find an equivalent in Access.

    Thanks,

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: name of VBProject (2002 SP2)

    Try this syntax (Debug window):

    ? Application.VBE.ActiveVBProject.Name
    NWTest

    The Access Application object has a VBE property that returns an VBE object from which you can get the ActiveVBProject & any of its exposed properties, such as Name.

    HTH

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: name of VBProject (2002 SP2)

    Perfect. Thanks Mark.

Posting Permissions

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