>Once upon a Time ....
>.
>.
>And Then ....
>.
>.
>And Now (to cut a long story short):

>Have a DB with 5 tables.
>Have code to export these 5 tables to 5 SEPARATE .XLS files. (piece-o-cake)
>Things were goin' great until the boss comes and says,
>"It would be nice to have ONE .XLS file, with 5 TABS (or Sheets) containing
>the 5 tables."

>Help!! How do I do it.
>I want to avoid doing the stuff using an EXCEL macro.
>Is it possible to do it by instantiating an excel object in an Access
>module?

>Any suggestions/links would be appreciated.
>I'm talking Access 97 and Excel 95.

>Thanking yuz.

>Cheers,
>Nolan