| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locate add-in
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locate add-in
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locate add-in
Try
Application.Help CreateObject("WScript.Shell").SpecialFolders("AppD ata") & "\Microsoft\AddIns" HTH Bob "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locate add-in
What do you have so far to call your help, and where.
Regards, Peter T "Basta1980" wrote in message ... 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 . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locate add-in
Hi Peter,
Dunno if i was doing it as it should be but I got it (the code) to work. Thnx Basta "Peter T" wrote: What do you have so far to call your help, and where. Regards, Peter T "Basta1980" wrote in message ... 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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate first value greater than | Excel Worksheet Functions | |||
| How to locate the value? | Excel Discussion (Misc queries) | |||
| STILL CAN'T LOCATE XML | New Users to Excel | |||
| Locate a change in Col | Excel Programming | |||
| Why can't locate the file? | Excel Programming | |||
Linear Mode
