Excel - named ranges

From: MS User (sqlman_at_sql.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 10:11:35 -0600

SQL 2K - DTS

I got a packge to load from Excel *** to database table. This Excel file
got many sheets and I have to just read from one of the sheet BUT it is
hidden.
Any links or tips for a VB script to create a name range for one of the
***.

Thanks
Jeff