LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Installing Addin Causes Serious Error in Excel 2002

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
installing Analysis toolpak in Excel 2002 without the installation Obrad Excel Discussion (Misc queries) 1 July 31st 08 06:07 PM
Addin Error after installing Excel 2003 SP3 , does anybody have same problem? Zoo Excel Programming 0 October 26th 07 06:53 AM
installing an addin drumerboy[_8_] Excel Programming 4 April 25th 06 08:38 PM
Installing Addin via Automation Aragorn[_2_] Excel Programming 6 October 26th 05 10:54 PM
Addin Not Installing zSplash Excel Programming 3 April 15th 04 07:40 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"