From: Dave Rose <bitdoger2@...>
Date: 2007-02-03T01:20:09+09:00
Subject: Re: win32ole question....

David Mullet wrote:
> On Feb 1, 4:08 pm, Dave Rose <bitdog...@yahoo.com> wrote:
>> can anybody point me to a good web page or know how to:
>> using ruby's WIN32OLE  'save as' a current
>> Worksheet into a csv format by only using
>> ruby's WIN32OLE access?
>>
>> --
>> Posted viahttp://www.ruby-forum.com/.
> 
> workbook.SaveAs 'myfile.csv', xlCSV
> 
> ...where xlCSV = 6.
> 
> http://www.rubygarden.org:3000/Ruby/page/show/ScriptingExcel
> 
> Mully

thanx...fyi...it's a combo of both of your response...i did a macro and 
used your's above to get...
excel.ActiveWorkbook.SaveAs("c:\\augcsv\\myfile1.csv", xlCSV)
...where xlCSV = 6.
...dave

-- 
Posted via http://www.ruby-forum.com/.