I am using some code snipets from other sources to access Excel files using ActiveX. It works fine. The app reads the xls file and extracts test setup info and limits. Each row of the file corresponds to a different set of parameters. It would be nice to be able to keep reading to the end of the spreadsheet and return a dynamically sized array. What I need is a way to know when to quit reading. Currently reading empty cells gives me a return of zero, which can be a valid parameter. I would like to not have to do something like a magic number in the cells or placing a row of ======== if possible. Anybody know the ActiveX method for determining the length of the file. I have the reference, but someone has it borrowed at the moment. Thanks.
