Consulting

Results 1 to 4 of 4

Thread: Retreive Add-in path

  1. #1
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location

    Retreive Add-in path

    Hi,

    What is the easiest way to retreive an active add-in path? I can get it for the active workbook, but am having trouble with the proper syntax. I've been playing around with ...

    Addins("myname.xla").Path
    But I'm not sure how to integrate it, or if that's even right.

  2. #2
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Hey Zack,

    Workbooks("myname.xla").Path
    Should work just fine for this!
    Matt

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Doh!

    I was under the impression I had to use the Addins Collection Object, well that was easy enough! LOL

    Thanks Matt!! Much appreciated! (especially when it's just slapping me in the face )

  4. #4
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Glad to help!

Posting Permissions

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