I'd like to write a VB script in excel to establish a connection to AS400.
After I run below scrap to open the connection in myCon.Open,
popup windows arise for login and pwd.
1) Can I place the login & pwd into the myCon.Open option?
(I checked IBM redbooks that it seems cannot)
2) I am fail to sendkeys to the popup to send login/pwd, don't know why.
3) How I can know I have successfully connect to the data source? Can I open a pComm session after the connect?
Thanks in advance!
Dim myCon As ADODB.Connection
Dim myRS As ADODB.Recordset
Set myCon = New ADODB.Connection
myCon.Open "Provider=IBMDA400;Data Source=SYSTEMNAME;", "", ""
(then login windows pop up as attached)