I want to open a Excel spreadsheet and save it as a text file.

[JAR]

I have excel spreadsheet files sent to me by staff members and I need to save the data on these files into text files. I would like to automate this due to the number of files I have to work with on a normal basis. I've found example of how to open the excel spreadsheets but I stuck there.

[K C]

Hi,

In one of my VI's I posted there is a read all data from spreadsheet into a array. Does this solve anything ?

[jdebuhr]

If you get K

C's Vi that would work to save it to text. I did something similar to what you want. I loaded an Excel Sheet, Sorted it and saved it to a text file. I did this using all ActiveX commands. I will look through my VIs and try to find it for you.

[jdebuhr]

I modified my Excel Sorting VI to open a XLS sheet and save it as a txt file. give this a try it should work for you. Oh yeah the Vi is in LV 7.1.1

Message Edited by jdebuhr on 10-24-2005 02:06 PM