ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Distributing an AddIn and Help File (https://www.excelbanter.com/excel-programming/309283-distributing-addin-help-file.html)

Marylena Garcia

Distributing an AddIn and Help File
 


I would like to distribute an AddIn (.xla) and its help file (.chm) . I
expect the user to save both file in the folder.
What can I do to keep the add-in linked to the help file without having
the user to update the path to the help file in the VBE when he/she
saves the file in his/her computer?

Marylena

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

...Patrick[_5_]

Distributing an AddIn and Help File
 
it is not possible with zip zip and a auto extrac file ?


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel


"Marylena Garcia" a écrit dans le message de
...


I would like to distribute an AddIn (.xla) and its help file (.chm) . I
expect the user to save both file in the folder.
What can I do to keep the add-in linked to the help file without having
the user to update the path to the help file in the VBE when he/she
saves the file in his/her computer?

Marylena

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




Frank Kabel

Distributing an AddIn and Help File
 
Hi
in VBA use
Thisworkbook.path
to get the current path of your addin and use this information to
reference the path of your helpfile

--
Regards
Frank Kabel
Frankfurt, Germany


Marylena Garcia wrote:
I would like to distribute an AddIn (.xla) and its help file (.chm) .
I expect the user to save both file in the folder.
What can I do to keep the add-in linked to the help file without
having the user to update the path to the help file in the VBE when
he/she saves the file in his/her computer?

Marylena

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Marylena Garcia

Distributing an AddIn and Help File
 


Thanks a lot,

Marylena

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com