Passing user name and password with VBA to intranet log-in
Posted on 2011-03-02
I have several processes that take about three hours to run. Right now, the user needs to log onto the intranet, enter their credientials to get to the underying reporting package. Since most of the users have their credientials "remembered", is there a way to do a SendKEy of some sort with VBA to OK the dialog box so the code can run, that is, get the excel worksheets from the intranet and downloaded into the local file? I would like to run this process around 6:00 am, but this manual OKing of the log in data stops this.