Logging on to a fileserver

Ok, so I’m writing a script that will launch an Excel Macro while I’m home sleeping. I’ve go it to do almost everything. Right now it will launch the necessary macro sheet, run the macro, print the result and log off from the file server (that has the info the macro needs).
The only snag is this: in order for the macro to log on to the file server, my username and password must be entered in the dialog box. I got the username taken care of by keeping an alias of the server in the “Recent servers” folder (in fact, that’s where the script looks to log on). However, I still have to be here to enter my password in the password field. Any idea of how to get the script to do this for me? This is the final step preventing me from having this mundane chore run completely independently. Thanks in advance.