Briefing Book Server

The Briefing Book Server compiles the Book each evening and distributes it to the appropriate users. The Server completes the following process:

• First, the Server runs a series of stored procedures that return result sets required to update the graphs.

• The result sets are written to an OLE 2.0 structured storage file. The first stream maintains properties for the graph, and each additional stream maintains a result set returned by the stored procedure.

• Microsoft Excel is then launched, and using OLE automation, the graphs are updated with the data in the structured storage file.

• The Visual Basic .MAK files are then compiled with the updated graphs and a self-contained .EXE file is created.

• Finally, the .EXE file is compressed and mailed to the appropriate user.