Open HTM file from Excel

  • Thread starter Thread starter Vikesh Jain
  • Start date Start date
V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving templete / workbook to a specific drive / file 1
Open Files in Folder 2
Table format - connection string problem 1
Problem opening a word file from Excel 2
Check a file into SharePoint 2
Combining several workbooks into one file 4
Macro won't open original file? 1
PowerPoint VBA question 1

Back
Top