Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |