We have a spreadsheet used by our vendors; we put certain data in it,
then the vendors put other data in it. The data we put in it changes
frequently and we'd like to be able have the workbooks update
dynamically whenever any vendor uses one, rather than send new
versions to our vendors.

The data lives in our database, and I'm familiar with using ADO to get
data from databases. But vendors don't have access to that internal
database.

What would be the simplest way to make the data available on the web
and use it in Excel?


Thanks,

Greg