Who's On?

	Membership:
	Latest: Julie
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5312

	People Online:
	Visitors: 374
	Members: 0
	Total: 374

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3290
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

AddIns launch multiple times on Menu Excel03

3 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

renecrozier

New Member

Posts: 0

3/30/2007 3:37 AM

This is a good one for everyone... We've stumped GSC and they keep pointing to Microsoft but I know they are going to tell me the problem is with Lawson Add-Ins.
The problem is after installing AddIns v205 or the v9 in Excel 2003 SP2 in our environment you cannot get the Lawson Query Wiz, Upload Wiz or Dril to display on the menu without a runtime error. If I comment out the line of code in VB that adds Lawson to the menu it produces it to the menu the next time you launch excel. However, every time you launch excel you have two more "Lawson" 's on the menu. By the end of the week you have about 50 or more and it just keeps adding them. You can still use the product and connect just fine but it's a pain in the rear to keep having to walk users through clearing their excel menu. GSC has been spinning their tail on this issue with us for over 2 months now with no resolution except it a microsoft problem.
I would appreciate any ideas you may have.
Thanks!

Deleted User

New Member

Posts: 0

3/30/2007 3:10 PM

Do you have any other addins loaded? I had an Essbase addin that would cause problems. I ended up having to remove it.

renecrozier

New Member

Posts: 0

3/30/2007 4:48 PM

I have other add-ins but not Lawson (ie. Crystal Reports etc.) they all work fine. The problem appears to be stuck in the code section as follows:

Set subMenu2 = subMenu.Controls(SUBMENU_BAR_NAME) When I comment it out it put's the lawson on the menu without the Runtime error but then keeps adding two more every time you open excel.

John Henley

Posts: 3359

3/30/2007 7:46 PM

Rene,
I have had to deal with this error before, and the only way I've been able to fix it is to completely uninstall the Lawson addins, Use Excel Tools|Addins to remove any traces, use Excel Tools | Macros | VBA | Tools | References to remove any traces of the Addins, and then re-install the addins.

Believe me I feel your pain!