Extract Data from an Excel Sheet and save it in an ASCII File

How can I extract some data from an excel sheet and save this data in an ASCII file, with a specific format?

Link excel sheet using createobject/getobject.

Then u can create ASCII file using Excel commands.

Hi


You could also get all the cell values into an Array (or multiple arrays if more than one worksheet) using the Excel object model. You could then simply write the array into any file format you want (I'd go for CSV myself).


Regards


Chris Eastwood


CodeGuru - the website for developers

http://www.codeguru.com/vb