• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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 !