Read in data from an excel spreadsheet?
Posted on 2006-04-10
I am using a vbScript and I need to be able to read in 4 columns of data from an excel file, and place these values into a dynamic array of some sort.
There are 4 columns of data in the excel sheet. The columns will be a different length everytime the code is ran, but the columns will be the same length as each other.
So after the code has executed I need to have the data from the 4 columns in an array (or 4 different arrays??), in the same order as it was in the excel spreadsheet.
Cany anyone provide this code?