I just posted some code last week that populates the first worksheet via automation (post date/time was 06/08/2000 17:11:31). If you look at the code, you may be able to figure out how to populate more than one worksheet. I haven't tried, but I'm guessing it wouldn't be too hard to figure out.

>I have a VFP table of summarized data that needs to be exported
>to an Excel workbook that will contain multiple (say 5) worksheets.
>The user requirements are that the data must be reported using
>Excel. That means output from the report writer or a PDF file is not an option.
>
>I know that I can easily populate the first worksheet of a workbook using COPY TO filename TYPE XL5. However, the additional worksheet
>can not be added this way (as far as I know).
>
>One way to populate the additional worksheets is via Excel automation
>to populate the cells one at a time (slow) or possibly via DataToClip / Paste. Another alternative is to create a COM component and call it from Excel. I've heard this can be done, but have not seen an example.
>
>Finally, it would also appear that I could benefit from using an Excel template. The template could handle the standarized layout
>and formatting that will be used in all worksheets. However, I have
>not seen an example of that either.
>
>My question is what is the best approach to solve this problem? Any example code or other ideas will be appreciated.
>
>Tom