Object: Excel DNA Intellisense. Link to a part of a help file
All That For That
In the IntelliSense sheet you may write a link to a web site.
Instead of this could I write a link to a help file and better to a part a this help file wich could be better to get help about a parameter for example.
Is it possible?
Thanks in advance for your help.
Govert van Drimmelen
Hello,
I assume from your question that you are using the hidden worksheet to provide the IntelliSense descriptions – probably for VBA functions.
If those assumptions are not correct, please write back.
I asked ‘Gemini 3.1 Pro’ to have a look at the IntelliSense code and answer your question.
This was the response:
“Yes, it is absolutely possible to link to a local help file instead of a website!
In the HelpTopic column (the 3rd column of your _IntelliSense_ sheet), you can enter the path to a local help file (such as a .chm file). If you just enter the file name (e.g., MyHelp.chm), IntelliSense will look for it in the same folder as your workbook.
To link to a specific part of the help file: You can append an exclamation mark (!) followed by your Help Context ID (Topic ID). For example, entering MyHelp.chm!105 will open MyHelp.chm directly to the topic associated with ID 105.
Regarding parameters: Currently, the IntelliSense feature only supports one help link per function, so you cannot create separate help links for individual parameters. However, you can link the function's HelpTopic directly to a page in your help file that contains all the detailed explanations for that function's parameters.
Let us know if you have any other questions!”
Regards,
Govert
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/a8877f0c-0bfc-4204-b861-6069663e267an%40googlegroups.com.
All That For That
You assume well :)
I did test few time ago but it did not work.
So I will retry several different tests.
Thanks again anyway.
Regards