Thanks for the input, it has worked. I realize after I read your response that I mistyped, I actually used a for loop, not a while loop, but the same concept works. I then put a Build Array function into the case structure so that each loaded file would get added to the array, so I end up with a 3D array, with each "sheet" being one file.
FYI, I am writing a subvi to load files based on a users date input. The 3D array will then be used in the analysis portion of the rest of the program.
-Sue K.