When starting AS400 for the first time every day it asks for an additional password via a small window titled "System i signon", however, I need to bypass this window.
Long story short, I have an Excel file with a connection to AS400 that, when triggered, opens a hidden AS400 window, gathers data via a macro within AS400, then closes the AS400 window upon completion. It works perfectly - with the exception of that pesky initial signon window. The problem is that I need to share my excel sheet with others who are not "techy" people so my sheet is setup so a user never even sees AS400, which means they don't know what to do if/when the signon window pops up.
That said, I want to create a batch file that (1) checks if the signon window is open, (2) enters the username, TAB, enters the password, ENTER, (3) does nothing if the signon window is not open. I've written extremely simple batch files and can execute them easily with macros, but this one is beyond my IT scope.
Any help would be immensely appreciated.
Software/Hardware used: AS400, Windows 10, BatchFile