Open HTM file from Excel
 

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

Open HTM file from Excel
 

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