How to run a com add-in (with log-in and password) with VBA (or maybe other solutions)
<p><a href="http://i.stack.imgur.com/tfMKl.png" rel="nofollow">update post of screenshots</a>I've got an COM excel add-in (name; Syntess Atrium Office add-in) which has a login button. When pushed i need to give a path to it's location on the server and after that I need a password to log in. </p>

<p>I need to run this Excel file a couple of times each month late at night with a scheduled task, and every time I need to be logged-in for it to function. So to make sure i'm always logged-in I want to create either a VBA script or any other script to push the log-in button, write down the path, hit enter, and then use my password and hit enter again. </p>

<p>The application (VBA excel sheet) runs at night because it takes several hours to create because of it's huge amount of data it takes from our financial database on the server(using the com add-in).</p>

<p>I hope someone can help me out! </p>

<p>I know I can use programs like Acces or even Excel it self for a direct link with the database, but our directors won't allow this, so that's not an option unfortunately. </p>