Open HTM file from Excel

[Vikesh Jain]

Dear All,
I am using Windows XP, Excel 2003

Please review the following code:

Sub OpenFunctionHelpFile()
Dim sPath As String
sPath = ThisWorkbook.Path

With ThisWorkbook
.FollowHyperlink sPath & "\Help on Custom Functions.htm"

End With
End Sub

Problem is when I run this macro, sometimes this works properly.
However sometimes when I run this macro, Excel crashes. I have tried
different files. also recreated the "Help on Custom Functions.htm" file
but to no benefit. Same problem occuring again and again. Macro working
sometime - at other times causing Excel to crash.
What should I do?
Is there some workaround to the same?
Thanks in advance
Vikesh Jain

[Vikesh Jain]

Dear All,
Can anybody help on this?????????
Thanks

Vikesh Jain wrote:
> Dear All,
> I am using Windows XP, Excel 2003
>
> Please review the following code:
>
> Sub OpenFunctionHelpFile()
> Dim sPath As String
> sPath = ThisWorkbook.Path
>
> With ThisWorkbook
> .FollowHyperlink sPath & "\Help on Custom Functions.htm"
>
> End With
> End Sub
>
> Problem is when I run this macro, sometimes this works properly.
> However sometimes when I run this macro, Excel crashes. I have tried
> different files. also recreated the "Help on Custom Functions.htm" file
> but to no benefit. Same problem occuring again and again. Macro working
> sometime - at other times causing Excel to crash.
> What should I do?
> Is there some workaround to the same?
> Thanks in advance
> Vikesh Jain