Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FollowHyperlink meathod closes workbook (Add-in) in 2003 and not 9
I have 1/2 a dozen add-ins that reference eachother, which are run by a menu.
They are all read-only and originally written in Excel 97. Now in Excel 2003, when this line of code runs, it causes an application error and terminates Excel (because the add-in is closed but is referenced by other workbooks). Note that these are not add-ins (Save as add-in), but rather the addin property of the workbooks are set to yes. ThisWorkbook.FollowHyperlink ThisWorkbook.Path & "\mydoc.doc" I can't assume there is a workbook open, and cannot set the saved property to false since they are read-only. I added "NewWindow:=True" to the end of this code, but this did not resolve the problem either. Any ideas? Another way to open a word doc? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Word closes Excel (2003) | Excel Discussion (Misc queries) | |||
ThisWorkbook.FollowHyperlink to Location in Workbook | Excel Programming | |||
looping a calculation until workbook closes | Excel Worksheet Functions | |||
Excel 2003 File Closes In 2000 | Links and Linking in Excel | |||
protect add-in after workbook closes | Excel Programming |