Martin
February 17th, 1999, 03:03 PM
How can I extract some data from an excel sheet and save this data in an ASCII file, with a specific format?
Click to See Complete Forum and Search --> : Extract Data from an Excel Sheet and save it in an ASCII File
Ratna
February 17th, 1999, 09:28 PM
Link excel sheet using createobject/getobject.
Then u can create ASCII file using Excel commands.
Then u can create ASCII file using Excel commands.
Chris Eastwood
February 18th, 1999, 02:48 AM
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
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
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.