Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Oct 8, 10:23*am, Jan Karel Pieterse
wrote: Hi Red, The problem appears to be uninstalling then reinstalling any addin using the Workbook_Open() procedure. WHat if you move the code out of workbook_open into a sub in a normal module and call that sub from workbook_open. If that doesn't help, try using the ontime method to call the sub Regards, Jan Karel Pieterse Excel MVPhttp://www.jkp-ads.com Member of: Professional Office Developer Associationwww.proofficedev.com Putting the commands in separate procedures and calling from Workbook_Open() didn't work BUT calling them using the Ontime function WORKED GREAT!!! Application.OnTime Now + TimeValue("00:00:01"), "UninstallAddin" '1 second delay Application.OnTime Now + TimeValue("00:00:02"), "ReinstallAddin" '2 second delay Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
installing Analysis toolpak in Excel 2002 without the installation | Excel Discussion (Misc queries) | |||
Addin Error after installing Excel 2003 SP3 , does anybody have same problem? | Excel Programming | |||
installing an addin | Excel Programming | |||
Installing Addin via Automation | Excel Programming | |||
Addin Not Installing | Excel Programming |