Is there a way to pass variables to an Excel Smartdocument pre-load?  I'm retrieving data from a DB and displaying it, and I've seen ways within the excel document to call and load the data(using menus and event handlers), but I'm trying to open up my Excel windows from a webform, and based on when/where it is called, I am going to want to load different data from the DB.  Right now I'm using a workaround of using handlers to "catch" the first 3 changes(the 3 variables I want to set), and then calling the datadisplaying functions, but I'd like to not have to deal with that and have the Sheet1_Startup() event handler fill in the data with variables that are already there. 

Any references or places I can look?

Hi Andrew,

It sounds like you're trying to modify an Excel doc outside of Excel.  This can be done through VSTO's ServerDocument class.  The "How to: Insert Data into a Workbook on a Server" tutorial is a good place to get started.

Hope this helps.

Ian