From: Jan Svitok Date: 2007-02-02T08:23:35+09:00 Subject: Re: win32ole question.... On 2/1/07, Dave Rose 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? I'd try this: (I'm assuming that you want to work with excel) 1. record a macro doing the desired action (i.e. start recording macro, save the worksheet as csv file and stop recording). 2. open VBA editor to see the source code of the macro 3. translate it into ruby/WIN32OLE For the last step, you'll need to pick up only part of the macro - there'll be probably other commands that you don't need. Look the commands in the help or on MSDN to see what they do. For the Ruby part, there's a chapter on this in Programming Ruby (http://ruby-doc.org/docs/ProgrammingRuby/html/win32.html). You can search the archive of the list for more info (Li Chen was a guy that worked a lot with Excel, so look up his threads)