From: mully <david.mullet@...>
Date: 2006-12-12T23:30:07+09:00
Subject: Re: Using the SaveAs in Excel not working with Ruby

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