simple question: how to open a htm file in vba

[Biedubbeljoe]

How do I open a htm file in vba,
while my active workbook/sheet stay'open?

Private Sub ShowHelp_Click()
Unload Me
Show.HelpFile.htm
End Sub

 

[Norie]

You could use the Shell statement:

Sub Test()
Dim retval
    
    retval = Shell("C:\Program Files\Internet Explorer\iexplore.exe C:\all.html")
End Sub

Replace the path to Internet Explorer and the html file.

Orr you could try this

ActiveWorkbook.FollowHyperlink "C:\all.html"

 

[Biedubbeljoe]

I took the second option, because the helpfile is in the same directory as the xls file.
And it worked! Thanks.

 

[Andrew Poulsom]

You can also associate a Help file with your workbook.

In the VBE click your workbook in the Project window and choose Tools|VBA Project Properties. On the General tab type or browse for your help file name in the Help File Name box and click OK. That done you can use the HelpContextID property of your CommandButton to assign it a specific topic in your Help file.

 

[Biedubbeljoe]

Thanks for tip!

 

[Biedubbeljoe]

The followhyperlink worked fine with my pc but not with others, so I set up Andrews posibility.
In the VBE click your workbook in the Project window and choose Tools|VBA Project Properties. On the General tab type or browse for your help file name in the Help File Name box and click OK. That done you can use the HelpContextID property of your CommandButton to assign it a specific topic in your Help file.
I did all that, my helpfile is a word.doc and it's in the same directory as the xls file.
What do I have to put into my:
code:
---------------------------------
Private Sub ShowHelp_Click()
Unload Me

End Sub
---------------------------------
because it doesn't work..
The problem is that I can't do the shell option, because the two files can be used in whatever directory, but always together. A fixed path is no option.

 

[Norie]

ASFAIK the file actually has to be a help file with the extension hlp. There are various tools for creating these.

When you say the hyperlink worked on your PC and not others what was the problem?

 

[Biedubbeljoe]

OK will look for the tool to convert to hlp of chm file.
I prefer not to look futher after I see that the error has something to do with application not found. The help file must be seen and found at all times..agree..

 

[Biedubbeljoe]

Ok, have made a help button on my sheet.
In vba I see:
code:
---------------------------------
Private Sub ShowHelp_Click()
Unload Me

End Sub
---------------------------------
In my project -> ShowFile -> HelpContextID = 1
project properties -> helpfile.chm -> ID =1

But if I push the button nothing happen..

 

[Andrew Poulsom]

The method I described is designed to work if the user presses F1 when the control has the focus.

Try this:

Private Sub ShowHelp_Click()
   Application.Help ThisWorkbook.VBProject.HelpFile, 1
End Sub