How to automate a process?

[st3ady]

Hey there,

I am the web/IT guy at my company, and I have to do this boring menial task each morning where I have to go to a certain website, click a certain link which downloads a zip file containing a Microsoft Access database file (.mdb) and then I need to extract it to a certain folder using winzip, and enter in the password (because the zip file is password protected, but stays the same every day) and then open up another database file and click run on the macro that appends the data into it.

Anyone have any ideas how I could turn all of this into a scheduled task? :confused: I remember back in the day I messed around with a program that records your clicks and mouse movements, would something like this do the job? Or are there programs that you can program to do all of this, like super complex .bat files...

Thanks :)

[ray326]

We used to use Wilson Window Ware's scripting language for that but I suspect you could do it with VBScript in the Windows scripting engine or whatever it's called. (That would be Windows Scripting Host or the WSH.)

[st3ady]

i just found a great freeware program called AutoIt