From: bbiker <renard@...>
Date: 2007-02-03T09:30:09+09:00
Subject: Re: win32ole question....

On Feb 2, 11:20 am, Dave Rose <bitdog...@yahoo.com> wrote:
> 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 viahttp://www.ruby-forum.com/.- Hide quoted text -
>
> - Show quoted text -

note: if the workbook already defined then workbook.SavesAs("c:/augcsv/
myfile1.csv", xlCSV) works