You can attach your own Help file to Excel document converted to application. Help file is stored
inside the application file. When application is copied to other location Help file is copied too and
can be accessed in new location.
By default LockXLS offers to select .chm file, but you can insert any document, even .doc or .txt file.
When application is launched, Help file is extracted and can be accessed from VBA macro:
' declare variable for LockXLS Runtime object
Dim oLockXLS As Object
' create LockXLS Runtime object
Set oLockXLS = CreateObject("LockXLSRuntime.Connect")
' Name of Help file is same as in file, which you've added to LockXLS project.
' For example: you file was MyFile.chm.
' If you need to show a specific topic (for example topic1.html) you should use the following call:
' release LockXLS Runtime object
Set oLockXLS = Nothing
LockXLS Runtime object has 2 methods to work with your own Help file:
GetHelpFilePath(< HelpFileName >) - returns path to your Help file extracted from application on customer's PC.
ShowHelpFile(< HelpFileName >, < Topic > (optional) ) - shows your Help file by calling HtmlHelp function.
Topic is a relative name of the html page included into help file. Second parameter is optional and can be omitted.
You can create your own code which will show a specific topic in Help file. If you use a more simple way and show default topic,
LockXLS offers to use ShowHelpFile method.
Contents of the Custom Help file are accessible on Ribbon (Office 2007) or Menu (Office 2000/XP/2003). LockXLS Runtime
adds item to ribbon's tab/menu relative to this locked file.
To provide your own caption for Help ribbon item, use Project Settings | Edit string table from this project ....
This Sample Project shows how to attach a Help file to project and call it using VBA macro.
Compare Excel Workbooks and VBA Projects
xlCompare - Compare and merge Excel Workbooks, Worksheets, Names and VBA projects, including
macros, forms and controls. 10+ Time saving commands.
Compile Excel workbook to EXE file
Looking for simple Excel Compiler? Visit xlCompiler website. Compile Excel workbook to standalone application.
Excel is not required.
Find out where result of a formula cames from
Dependency Auditor - Analyze and trace dependencies and
calculations in your workbook.
Complete list of the Spreadsheet Tools products
Visit Spreadsheet Tools home page to see
complete list of our products and company information.