• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Connecting with JDE by Excel's macro


I have question about connecting to JDE iSeries. Below you can see my JDE version.


I want to write in Excel macro wchich will getting some datas from JDE. Unfortunatelly on the beggining I have problem, because after open a programm I don't know how to log in to JDE using VBA.


After this code I see window for JDE and I don't know what should I do to log in to JDE. Below some photos.

3.jpg 4.jpg

Can you give me advise how can I connect with JDE?

Thank you in advance ! :)
Best regards !


hello, I'd like to know if you had the chance to connect excel macro to JDE. I'm trying to create Argentina's taxes flat files directly from excel to reduce costs and time. Did you?