Opening .chm files with VBA

[jwadd17]

How can I use VBA to open a .chm file. I tried using many different methods but with no success, i.e. openfilename.

Does anyone have any suggestions?

Thanks in advance for your help.

 

[Juan Pablo González]

Open it, how ? what do you mean ?

 

[jwadd17]

How can I use a macro to open the file with the click of a button?

 

[Juan Pablo González]

Ok, but when you say, open the file, you mean display the help file ?

If so, you can just use the Shell like this

Shell "Path and name of chm file", 1

 

[jwadd17]

Seems as though it would work well enough, but I get a runtime error saying "file not found." I pulled the path directly from windows so I know it's correct. Is there anything I might be doing incorrectly?

 

[utkarshsi]

public sub chmOpener()
Application.Help (ActiveWorkbook.Path\HelpFileName.chm")
end sub

 

[LeonardHarley]

Quick correction on the above:

Application.Help (ThisWorkbook.Path & "\HelpFileName.chm")