>I'd like to be able to take the first worksheet from multiple excel files and copy them all into a new workbook. So, say we had 3 xls files and each had data only on the first worksheet. I'd like to grab the first worksheet out of each of those files and add it to a brand new workbook that get's created through code. I would end up with a workbook that contains 3 worksheets of data. Thanks.
Did you try creating an Excel macro, and doing these actions manually? The idea is to see what commands are generated, and then translate that to Visual FoxPro.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)