Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when adding custom help file to custom function
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:MSITStoC:\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:MSITStoC:\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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when adding custom help file to custom function
here are links to everywhere I have posted this question:
http://www.microsoft.com/office/comm...cr=US&sloc=&p= http://www.microsoft.com/office/comm...c=en-us&m=1&p= http://www.microsoft.com/office/comm...cr=US&sloc=&p= http://www.microsoft.com/office/comm...r=US&sloc=&p=1 http://www.mrexcel.com/forum/showthread.php?t=331270 http://www.excelforum.com/showthread.php?t=650397 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Programming | |||
adding custom images to a button on custom toolbar | Excel Programming | |||
Adding IF statement to custom function (VBA)? | Excel Programming | |||
Custom Function - Adding Help Information | Excel Programming |