I'm afraid you cannot do this in a looping script if the worksheets have different names across the different Excel files.
It can be done one by one, but then you will have to adjust that in every import step.
Thanks. It is actually the same worksheet name in all the Excel files. It seems that by default the first worksheet is imported. We have hundreds of files but the worksheet that needs to be imported is the fifth worksheet in the file.
Software Engineer, Professional Services
RJ Lee Group
350 Hochberg Road | Monroeville, PA 15146
Please let us know if we've met your expectations on your project by visiting our Customer Survey.<http://survey.constantcontact.com/survey/a07e50m722ngth9ayc5/start
I did something rather like that but found I had to hardcode each import to designate the correct worksheet. In the file we were importing from were 40 worksheets - each had to be specifically designated in the import routine.
“There are two major products that come out of Berkeley: LSD and UNIX. We don’t believe this to be a coincidence.” --- Jeremy S. Anderson