Help Files

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Help Files

Post by Don Wells »

    Can someone point me towards good guidance in creating a Help File for use with a MsgBox in Excel VBA?

Many Thanks in Advance
Regards
Don

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Help Files

Post by HansV »

The HelpFile option is a remnant from the time that programs used "Windows Help" files (extension .hlp) instead of the HTML help files that prevail nowadays. In Office 2007 and as far as I know in Office 2010, the HelpFile and Context arguments are ignored, and the standard help window for the application is displayed. So I wouldn't bother.
Best wishes,
Hans

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Help Files

Post by Don Wells »

HansV wrote:The HelpFile option is a remnant from the time that programs used "Windows Help" files (extension .hlp) instead of the HTML help files that prevail nowadays. In Office 2007 and as far as I know in Office 2010, the HelpFile and Context arguments are ignored, and the standard help window for the application is displayed. So I wouldn't bother.
I'm a dinosaur still using 2003. Does that impact your response Hans?
Regards
Don

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Help Files

Post by HansV »

It still works in Office 2003, but do you really want to invest time and effort in a technology (.hlp files) that is being phased out, and that is not supported in newer versions?
Best wishes,
Hans

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Help Files

Post by Don Wells »

Many Thanks Hans     :cheers:
Regards
Don

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15636
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Help Files

Post by ChrisGreaves »

Don Wells wrote:Many Thanks Hans     :cheers:
Well, I suppose you could always just place a link to a PM to Hans.
That'll larn 'im! :laugh: :rofl:
There's nothing heavier than an empty water bottle

Becks
2StarLounger
Posts: 196
Joined: 31 Mar 2011, 03:41
Location: Perth, Western Australia

Re: Help Files

Post by Becks »

I have seen code for a custom message box that will use an API function call to open a compiled help file - just because Microsoft no longer believes in providing explanatory help files doesn't mean that we have to agree withthem :grin:

Kevin