|
-
February 17th, 1999, 04:03 PM
#1
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?
-
February 17th, 1999, 10:28 PM
#2
Re: Extract Data from an Excel Sheet and save it in an ASCII File
Link excel sheet using createobject/getobject.
Then u can create ASCII file using Excel commands.
-
February 18th, 1999, 03:48 AM
#3
Re: Extract Data from an Excel Sheet and save it in an ASCII File
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
