Consulting

Results 1 to 4 of 4

Thread: Solved: Retreive Add-in path

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

    Solved: 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 ...

    [VBA]Addins("myname.xla").Path[/VBA]

    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,

    [VBA] Workbooks("myname.xla").Path[/VBA]

    Should work just fine for this!
    Matt

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,897
    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
  •