Is there a way to get the Add-in path location through macro

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
Hello

I am trying to add a dynamic label that will allow me to see the path of my XLA add-in...

Is their a way to do so?

Thanks a lot...

Joe
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening Ragnar78

Try :

Code:
Sub Test()
MsgBox AddIns("Analysis ToolPak").Path
End Sub

HTH

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top