View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Database link to worksheet!

Another thought. I've assumed you want the database to notify the
template when something changes in the database, so that when a
workbook is created from the template it will have the current data.
As an alternative, you could, at the time a workbook is created from
the template, get the workbook to query the database. This is how
databases are normally used i.e a client application queries a
database server for the current data, rather than the other way round!

Jamie.

--