Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
"Lonnie M." wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
P.S. Word will work just fine too.
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
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 On Mon, 20 Dec 2004 09:29:05 -0800, Ligaya wrote: 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
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/...ndx/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/plan...lps/Index.html -- HTH RP (remove nothere from the email address if mailing direct) "Ligaya" wrote in message ... 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 = |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Helpfile within Excel
"Bob Phillips" wrote: 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/...ndx/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/plan...lps/Index.html -- HTH RP (remove nothere from the email address if mailing direct) "Ligaya" wrote in message ... 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 = 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
The "networkdays" function doesn't work even with helpfile example | Excel Discussion (Misc queries) | |||
MyHelp - VBProject.Helpfile | Excel Programming | |||
Open Helpfile from Excel VBA or hyperlink | Excel Programming | |||
Unable to launch html helpfile | Excel Programming |