Re: Excel VBA - Linking .hlp help file to Function Wizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Charles,

Recent post from JKP of Daily Dose set me thinking too.
I've just mailed you my code. (Crashproof,no xlmsheet,
unloading/reloading)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Charles Williams wrote in <news:<OIYH53KPGHA.2268@xxxxxxxxxxxxxxxxxxxx>

Try something like this

Application.MacroOptions Macro:="CalcSeqCountRef",
Description:="Calculation sequence counter for the referenced cell",
Category:=9, HelpFile:=ThisWorkbook.Path & "\FastExcelUser2.hlp",
HelpContextID:=309

If that does not work there is also a much more complex and
troublesome method using XLM macros & hidden namespaces etc (I have
just spent 4 days getting it to work....)

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Jsadleir" <Jsadleir@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD53054D-A9EE-42F5-9C71-1FD8E776B204@xxxxxxxxxxxxxxxx
Hi Coders

I have written a series of vba functions and I want to provide
context-sensitive help for each of these functions from the help
file hyperlink on the function wizard. Using HelpScribble
(www.helpscribble.com) I was able to put together a .hlp help file
and load the right help file page for each individual function. (I
used a .hlp file rather than the newer .chm files because the .chm
would never load properly).

My problem is that with some earlier versions of Excel (well Excel
2000 9.0) I can only find the .hlp file if I manually unlock the
VBA password protection, go to the VBA Project's properties and
click on the ... button to direct Excel to the .hlp file. I have
tried saving the .hlp file in many different folders (windows,
office, library etc) but have not found a folder that Excel
defaults to when looking for help files. I have tried entering an
absolute path in the Help File field but that does not work either.

Is there a way to do this programmatically through VBA (ie tell the
VBA project where the help file is)?

I am able to find the path to the help files using SHGetFolderPath
(Shell32) and can call a particular help topic with WinHelp
(user32), but neither of those API calls are useful if I can't
detect from the VBA project the click event that occurs when the
function wizard hyperlink is clicked.

Any thoughts or suggestions would be much appreciated.

Regards

Jeremy
.

Relevant Pages

  • Re: Available functions within Excel VBA
    ... The list of VBA functions is in the Excel VBA help file. ... For worksheetfunctions from Excel which can be used in VBA, ... Regards, ...
    (microsoft.public.excel.programming)
  • Re: Excel VBA - Linking .hlp help file to Function Wizard
    ... but for some reason the Help File is never found even with the path ... hyperlink on the function wizard. ... I can only find the .hlp file if I manually unlock the VBA password ...
    (microsoft.public.excel.programming)
  • Re: Excel VBA - Linking .hlp help file to Function Wizard
    ... was able to put together a .hlp help file and load the right help file ... My problem is that with some earlier versions of Excel (well Excel 2000 ... I can only find the .hlp file if I manually unlock the VBA password ...
    (microsoft.public.excel.programming)
  • Re: image resize picture
    ... >> of those page actually explained anything about the WITH keyword. ... I didn't mention the help file because this is what I had for my help ... WITH OWNERACCESS OPTION Declaration ... I always chose VB since I didn't have any experience with VBA. ...
    (microsoft.public.vb.general.discussion)
  • Re: Revisions programming: where to find info?
    ... The best source of info is probably the vba help file. ... Dim myrange As Range, arev As Revision, i As Long, source As Document, ... Everything seems to be> different than programming regular text in paragraphs. ...
    (microsoft.public.word.vba.general)