locate add-in

[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

 

[Peter T]

Application.UserLibraryPath

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

Regards,
Peter T

 

[Basta1980]

Hi Peter,

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

Mvg,

Bas

 

[Bob Phillips]

Try

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

HTH

Bob

 

[Peter T]

What do you have so far to call your help, and where.

Regards,
Peter T

 

[Basta1980]

Hi Peter,

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

Thnx

Basta