in reply to execution of program without dialogue prompting up.

By using the DisplayAlerts property (Application.DisplayAlerts = False)
So it should be like :
$Excel->{DisplayAlerts} = "False" $Book_Schedule->SaveAs("$file"); $Excel->{DisplayAlerts} = "True" $Book_Schedule->Close;