From: anon1m0us@...
Date: 2006-12-12T23:40:05+09:00
Subject: Re: Using the SaveAs in Excel not working with Ruby

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