Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an addin that saves itself in either the BeforeClose of
AddinUninstall events. If for some reason I open multiple Excel instances, when I close the one of the later instances the line ThisWorkbook.Save saves the addin to the active Excel directory, e.g., My Docs. No error is generated, it just saves a copy to the wrong place. It's not a big problem if the addins in the multiple instances are not saved. So instead of ThisWorkbook.Save I wrote code that uses ThisWorkbook.Saveas and surrounded it with On Error statements and turned of DisplayAlerts: If Not ThisWorkbook.Saved Then 'in case it's read-only, which would be true if this were the 2nd (or more) instance of Excel On Error Resume Next Application.DisplayAlerts = False 'I did SaveAs, because if it's read only Save will save to the active Excel Directory ThisWorkbook.SaveAs Filename:=ThisWorkbook.FullName Application.DisplayAlerts = True On Error GoTo 0 End If Exit Sub ErrorHandler: Application.ScreenUpdating = True Application.DisplayAlerts = True This solution falls under the category of "crude but effective, I hope." Does anybody have a better one? XL03 Win Vista and XP Thanks, Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
running multiple instances | Setting up and Configuration of Excel | |||
addin not running correctly | Excel Programming | |||
addin not running correctly | Excel Programming | |||
Load xla addin on demand for particular Excel instances | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |