locate add-in

  • Thread starter Thread starter Basta1980
  • Start date Start date
B

Basta1980

Hi,

I've an add-in which I want to distribute to colleagues. There's also a
helpfile attached. I programmed the location of the helpfile in the add-in.
Currentley it refers to my D:\ but I want to let it refer to the D:\ of the
specific user

Application.Help "D:\Users\<username>\Application Data\Microsoft\AddIns

I think I can use the Application.Username to name the variable but how do I
incorporate the statement within the application.help?

Gr.

Bas
 
Application.UserLibraryPath

If you ensure the help file is in the same path as your addin,
ThisWorkbook.Path

Regards,
Peter T
 
Hi Peter,

I'm a real newbee on this. Could you help me where to put this code?

Mvg,

Bas
 
Try

Application.Help CreateObject("WScript.Shell").SpecialFolders("AppData") &
"\Microsoft\AddIns"

HTH

Bob
 
Hi Peter,

Dunno if i was doing it as it should be but I got it (the code) to work.

Thnx

Basta
 
Back
Top