Excel 2007 error when adding custom help file to user defined function

**sabotuer99** · 07-19-2008, 12:32 AM

I created a function in VB and wanted to add a help file, so that when you
pull the function up in "insert function" you could click on "help with this
function" it pulls up the function. After some digging I discovered how to
do this:

right click "VBAProject (MyAdd-in)"
VBAProject Properties...
Help file name (browse to help file)
assign context id

Then, in the code window,
bring up object explorer (F2),
navigate to my function,
right click, select "Properties...",
and enter context id assigned above.
(Note at this point that the "Help File" field, which can't be edited,
contains the same file location entered in the VBAProject Properties above...)

save project, flip back to excel, insert function, find mine, click "help
with this function" and viala it works.

Now the weirdness starts.

When I close and reopen excel, try to click "help with this function" again
and I get this error:

"Cannot open the file: mk:MSITStore:C:\Program Files\Microsoft
Office\Office12\????."

So I try everthing I can find about this error (.ocx files, reregistering,
MJ's Tools, etc.) and nothing works.

When I navigate back to VBAProject Properties, the help file address is
still fine.
However when I go to the properties for my function, the "Help File" field
now reads "????" instead of the help file from VBAProject Properties.

So I go back to VBAProject Properties and enter "test" in the help file
field. I check my function and "Help File" now reads "test". I save and go
back to excel. Try clicking the link and low and behold I get this error:

"Cannot open the file: mk:MSITStore:C:\Program Files\Microsoft
Office\Office12\test"

So when I reload excel it is corrupting the address for the help file for my
function and apparently the only way to resolve it is to load and resave in
VBA everytime I open excel (not exactly convenient)

So how does one get word to MS that there is something screwed up in excel?