How to execute a file in vba

[pazgb]

I have a help file system that i want to be executed on a button but I can't figure out the code to execute it.

Can anyone help?

 

[smedvid]

Perhaps the SHELL() may be the answer? Personally, I create PDF's and create a Hyper-link. Another approach I have used is to have embedded objects within a table within the database and then have a Books-Online approach. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[VBslammer]

Just assign the help file to the form's HelpFile property and in the button's Click event add:

[tt]
Private Sub cmdHelp_Click()
SendKeys "{F1}"
End Sub
[/tt]

You can use the API also if you're feeling more technical, but it will depend on whether your help file is HTML help or WinHelp.

VBSlammer

Unemployed in Houston, Texas

 

[pazgb]

my help file is HTML help and i set the helpfile property to my helpfile and left the helpcontextID to 0 which is default, but it still gives me Microsoft Access's helpfile.

any more options?

 

[VBslammer]

You'll need to provide a HelpContextID.

VBSlammer

Unemployed in Houston, Texas

 

[pazgb]

Im using HTML Help Workshop, do you know how to create helpcontextid's?

 

[oharab]

YUCK. Context sensitive help! Useful, but a pain in the ass to use!!

If all you need to do is open the hlp file, use the code in m FAQ:faq705-1971 and just pass it the name of the help file.

Cheers

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[VBslammer]

You just create a header file with a .h extension (add it to the 'Map' section on the HTML API Information dialog) and add your IDs like this:

#define IDH_BACKEND	1000
#define IDH_INSTALL	1001

Then you associate the IDs with specific .htm files using the 'Alias' tab on the dialog.

IDH_BACKEND=Content\BackendFiles.htm
IDH_INSTALL=Content\Installation.htm

That's it. The context IDs for this example 1000 and 1001



VBSlammer

Unemployed in Houston, Texas