Adding a password when opening excel

[bristolweatherman]

When autoIT opens an excel file the password dialog box opens.

I want autoIT to add the password and then press enter.

Here is an extract from my script.

$filename = "Q:\Excel QLX reports\repair_orders.xls"

$oExcel = ObjCreate("Excel.Application")

$oExcel.Workbooks.Open ($filename).Sheets (1).Select ()

$oExcel.Visible = True

I think from looking at the form I need to use winactive?

Perhaps send ("{ENTER}" but I cannot get it to work.

Please can I have a few lines of code to enter the password?

Also if I want to schedule an autoIT script to run every monday morning can someone suggest some software to do this?

Thanks

Mark