Thread: locate add-in
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default locate add-in

Hi Peter,

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

Mvg,

Bas

"Peter T" wrote:

Application.UserLibraryPath

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

Regards,
Peter T

"Basta1980" wrote in message
...
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



.