Thanks...that did the trick! mully wrote: > anon1m0us / yahoo.com wrote: > > How can I save the workbook without this prompt. > > Where xl is your Excel Application object and wb is your Workbook > object... > > xl.DisplayAlerts = 0 > wb.SaveAs(xlsname) > xl.DisplayAlerts = 1 > > > In addition, is there away to add a timestamp to the save file > > like.....application12122006.xls or any format that contains a time > > stamp? > > Something like this... > > xlsname = 'application' + Time.now.strftime("%m%d%y") + '.xls' > > Mully