Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Lawson Add-Ins for Microsoft Office
Automating Excel Add-In JE Import with VB
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
254
Members:
0
Total:
254
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Add-Ins for Microsoft Office
Automating Excel Add-In JE Import with VB
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
marknorris
New Member
Posts: 2
9/14/2007 4:15 PM
Our company is trying to automate journal entry and AP uploads to Lawson using the add-in wizard. We would like to use macros and visual basic but have not found any documentation on how to call the Lawson add-in object. Can someone point us in the right direction?
John Henley
Senior Member
Posts: 3348
9/14/2007 5:05 PM
Hi Mark,
The short answer is that you can't control the Excel Addins via VBA. The only thing you can do is invoke/start the wizard.
Attachments
191454622671.gif
John Henley
Senior Member
Posts: 3348
9/14/2007 5:10 PM
A couple of anecdotes for you:
- The Addins were originally created as a marketing tool to slicken up the Lawson demo. After a few prospects turned into customers, they complained to Lawson, "hey, where's that Excel tool we saw in the demo???" So, the irony is that apparently Lawson really didn't plan this as a product...
- After the Addins were released as a product, I talked to the developer, and asked him your exact question, and asked him to imagine the value they could deliver if they could VBA-enable the addins. Essentially, you could write your interfaces/conversion in VB, and use the addins to pump the data in/out of Lawson. His response:"Gee, we didn't even think of that...that's a great idea!"
marknorris
New Member
Posts: 2
9/14/2007 5:13 PM
So where is this developer now? Still with Lawson? We have cash, does he work on the side?
Deron
Advanced Member
Posts: 25
10/3/2007 5:38 PM
We had a need to load journals via add-ins. One of our consultants provided a template which used VBA to mimic the upload function. It wasn't working perfectly, so I tweaked it a little bit and we are able to load both the 40.2 and the 40.1 records when doing jes. It's limited to 1000 records, but that's usually more than enough for our purposes.
awolff01
Basic Member
Posts: 8
10/4/2007 1:38 PM
Mark,
You can create very sophisiticated upload macros to Lawson using VBA/Excel and Lawson's Addin API.
I recently developed a GL40 upload macro that even allows the user to create a journal number if one is not provided.
I have also created upload spreadsheets for Inventory Control, Purchase Order, Billing. Etc.
If you need more info contact me offline aleksei_wolff@yahoo.com
Thanks.
John Henley
Senior Member
Posts: 3348
10/4/2007 1:57 PM
Alex, are you saying you were able to control the Addins via VBA??? The only control/object method I see in VBA is to start the wizard...
John Crudele
Veteran Member
Posts: 50
10/4/2007 5:03 PM
You are not using the add-ins, VB mimics the add-ins. If you attended the add-ins class at CUE, the instructor gave everybody this link. Look at the self contained worksheets, they contain the VB programming. If you know a little VB it is very easy to modify the samples or create new ones.
http://solutions.lawson.com/lu/addins/main.htm
Regards
JC
John Henley
Senior Member
Posts: 3348
10/4/2007 5:23 PM
Oh, I thought you were talking about something new and improved. Those have been around for a long time...but have been updated from writing to database tables (e.g., GLTRANSREL) to calling AGS.
The original question in this thread was how to automate the JE process using the Addins, the answer to which is "you can't".
But, as John and Alex point out, you can use Excel VBA to upload data via AGS ...
Jonathan Campbell
New Member
Posts: 1
11/9/2008 9:44 PM
Whenever I attempt using the self-contained JE upload file, I get an error saying "
" in the GL40.2 message. Did anyone else have this problem? If so, how did you fix it?
jeremy.zerr
Advanced Member
Posts: 23
11/10/2008 8:59 PM
I haven't been able to control the add-ins via VB, but just like the Query Wizard, the Upload Wizard generates a web query, an AGS call string for an Upload. You just click on the magnifying glass after you run the Upload and it gives you the query.
You'll be able to figure out what the URL parameters are for, then you can use some VB or whatever to loop through a spreadsheet and call that AGS URL with your parameters for each line. It essentially is doing what the Upload Wizard is doing.
I just think of the Office Add-ins as URL generators that save me a lot of time, then I use that URL in other programming environments to make it part of a more automated solution.
Jeremy Zerr
Lawson Reporting
joel_f
New Member
Posts: 1
12/5/2008 3:18 PM
Jeremy~
I'd like to complete a query using the URL generated by the Query Wizard in a vba environment. Have you done something like this? When I attempt to connect though, it gives me an authetication error. Here's the code I'm working on:
public sub GetLawData(sUrl as String)
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.ServerXMLHTTP")
Call objHttp.Open("GET", sUrl, False)
Call objHttp.Send("")
Call MsgBox(objHttp.ResponseText)
Set objHttp = Nothing
End Sub
You are not authorized to post a reply.