I don't think there's a way around this within Monarch.
However, this problem seems like an ideal candidate for a little automation, as it has the same steps every day. So...
I'll be the first to admit that this isn't the most robust code ever written. More quick and dirty than anything, but it works.
This is an Excel macro. You should be able to copy and paste it into a macro module in a new workbook.
Dim objMonarch As Object
Dim bSuccess As Boolean
Dim sMasterBook As String
Set objMonarch = CreateObject("Monarch32")
bSuccess = objMonarch.SetReportFile("C:MyTestKruncher data.txt", False)
bSuccess = objMonarch.SetModelFile("C:MyTestKruncher model.xmod")
bSuccess = objMonarch.JetExportTable("C:MyTestKruncher Export.xls", WorksheetFunction.Text(Now, "mmm d yyyy"), 0)
'password is "test"
Workbooks.Open "C:MyTestKruncher test.xls", , , , "test"
sMasterBook = ActiveWorkbook.Name
Workbooks.Open "C:MyTestKruncher Export.xls"
'save and close the exported data workbook
'save and close the master workbook
End Sub[/font][/quote]Change the folder and file names as necessary, and the password, and you should be OK. Oh, and go to the Tools menu and set a Reference to Monarch (check the Monarch box).
Of course, if someone posts a Monarch based solution, I've had some fun programming.