Is there a way in Active X to set an Excel worksheet
object (from a parameter) and loop through the tabs
importing data? Our client insists on keeping critical
data in spreadsheets that need to be uploaded on a nightly
basis. The sheets vary in numbers of tabs, and I would
rather not hardcode them.

Thank you,
Ray

Are all sheets the same structure ?

If yes then you can loop through the worksheets collection and set the
properties as you go.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ray" <anonymous (AT) discussions (DOT) microsoft.com> wrote