View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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!