It's would not be a "light" workbook, it's quite heavy.

Assuming you follow the usual way of extracting data from MSSQL (ADO on top
of OLEDB) you will need to have code to

1. Connect to the database.
2. Select the 'correct' code
3. Access the workbook to either add the code or create a reference to a
downloaded code object.

So, you have to ensure that the user has ADO, trusts access to the excel
development environment and/or has a certificate for your code installed.

This is basically a bad idea - try another way. Good luck


--
www.alignment-systems.com


"Hiran de Silva" wrote:

Hi,

Have anyone got a workable plan for this?

I want a 'light' Excel 2000 workbook to get VBA code from a (SQL Server
2000) database and run it. ie. to create an Excel application 'on the fly'.

The plan is to distribute a generic workbook to users around the world, so
that we can keep adding and improving features indefinitely.

All thoughts welcome.
Thanks,
Hiran