Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

VBA code to launch lawson add-in 10.0.7

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


harold_c











Basic Member



Posts: 9




Basic Member



7/19/2016 11:42 AM

    Anybody knows the code to launch the Lawson add-in 10.0.7 from Excel?

     

    We used to be able to run it in the older version because we can see it in the VBA editor, but with the new version (VSTO), we could not see the code anymore and don't know how to call it.

     

    Your help is appreciated. Thanks.

     

    Harold



    ggould











    Basic Member



    Posts: 4




    Basic Member



    7/2/2020 6:54 PM

      I would love to know this as well.  We need be able to call the Lawson Upload Wizard via a VBA module within Excel, rather than through the Add-Ins tab.



      John Henley














      Posts: 3353







      7/24/2020 2:34 PM
        You cannot control add-ins from VBA/macros. Don Peterson from Lawson/Infor has created some "self contained workbooks" that are available on the Infor/Lawson support site that use VBA code to connect to Lawson for authentication, and make AGS/Transaction calls (which is what the add-ins do under the hood). Somewhat intimidating for someone not comfortable with VBA and HTTP, but very powerful There are several installation dependencies, etc. that he documents in his very detailed instructions.
        Thanks for using the LawsonGuru.com forums!
        John