Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Question (Microsoft Project 2000 (9.0.2000.0224))

    I would like to write some VBA code to identify, for the active project, what the active view name, table, and filter is. Has anyone done this? Can you post some sample code? I have looked at the Project model, but haven't seen what I was looking for. Thanks.

    Dick

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: VBA Question (Microsoft Project 2000 (9.0.2000.0224))

    Dick,

    Try the following:

    Dim ViewName As String
    Dim TableName As String
    Dim FilterName As String

    ViewName = ActiveProject.CurrentView
    TableName = ActiveProject.CurrentTable
    FilterName = ActiveProject.CurrentFilter

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Question (Microsoft Project 2000 (9.0.2000.0224))

    Gary,

    Thank you. It works just fine.

    Dick

Posting Permissions

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