Prev
Next
Forums Lawson Add-Ins for Microsoft Office

AddIns launch multiple times on Menu Excel03

Sort:
You are not authorized to post a reply.
Author
Messages


renecrozier











Basic Member



Posts: 4




Basic Member



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!


    goldfinger











    New Member



    Posts: 1




    New Member



    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











      Basic Member



      Posts: 4




      Basic Member



      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











        Senior Member



        Posts: 3348




        Senior Member



        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!
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.