Create a Helpfile within Excel

[Guest]

Hi.

I have not done this and do not know how to go about it.

I have an Excel file with all my vbs and would like to include a
help(instructions to use the macros) by including this in the Excel Menu. Is
there any reference or MS site that I could find to help me through the steps
to create a Help File?

Tanhk you.

Ligaya

 

[Lonnie M.]

Hi, something simple I have done in the past is create an HTML help
file and then launch it from a command button.

Private Sub cmdHelp_Click()
ThisWorkbook.FollowHyperlink Address:=ThisWorkbook.Path &
"\Help\index.htm"
End Sub

HTH--Lonnie M.

 

[Guest]

Hi, something simple I have done in the past is create an HTML help
file and then launch it from a command button.

Private Sub cmdHelp_Click()
ThisWorkbook.FollowHyperlink Address:=ThisWorkbook.Path &
"\Help\index.htm"
End Sub

HTH--Lonnie M.

Lonnie,

Could I use Front Page or could your recommend a sftware to do htm file.
Word probably is good. How do I include the file with the excel app program
if I want to share it with another user?

Thanks.

Ligaya

 

[Lonnie M.]

Ligaya,
Front Page would work great. When you distribute it, zip the excel file
and then add the help file. When it is extracted it will extract the
help file and directory with the excel file.
Regards--Lonnie M.

 

[Lonnie M.]

P.S. Word will work just fine too.

 

[Gord Dibben]

Ligaya

You could pop up a UserForm as John Walkenbach demonstrates.

http://www.j-walk.com/ss/excel/tips/tip51.htm

Gord Dibben Excel MVP

 

[Bob Phillips]

Ligaya,

I use the Microsoft HTML Help Workshop for this.

Create a number of HTML pages for each section of help, including hyperlinks
within the pages, and then use the HTML Help Workshop to create a chm file.

You can get the workshop at
http://www.microsoft.com/office/ork/xp/appndx/appa06.htm

Look up in Google for some tutorials on using the workshop, but here are a
couple
http://www.gary-conroy.com/library/weekly/aa013000a.htm
http://www.io.com/~tcm/etwr2373/planners/ms_helps/Index.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

Hi.

I have not done this and do not know how to go about it.

I have an Excel file with all my vbs and would like to include a
help(instructions to use the macros) by including this in the Excel Menu. Is
there any reference or MS site that I could find to help me through the steps
to create a Help File?

Tanhk you.

Ligaya

5gaya

=

 

[Guest]

Ligaya,

I use the Microsoft HTML Help Workshop for this.

Create a number of HTML pages for each section of help, including hyperlinks
within the pages, and then use the HTML Help Workshop to create a chm file.

You can get the workshop at
http://www.microsoft.com/office/ork/xp/appndx/appa06.htm

Look up in Google for some tutorials on using the workshop, but here are a
couple
http://www.gary-conroy.com/library/weekly/aa013000a.htm
http://www.io.com/~tcm/etwr2373/planners/ms_helps/Index.html

--

HTH

RP
(remove nothere from the email address if mailing direct)



=

Thank you everybody. Now I have some directions and not totally clueless.
I'll work on this during the holiday vacation. I'll let you know how
everything went .

Regards to all

Ligaya