Excel and VB.NET

[ross1664]

I particularly like the Publish facility within VS 2008 (VB). What I actually want to do is use the same facility for a Spreadsheet. I.E. I have a Spreadsheet with a chunk of VBA code behind it. Is there anyway to incorporate the spreadsheet into a VS 2008 VB project so that I can use the "Publish" facility to distribute updated versions of the spreadsheet from a web page (As created by the Publish Wizzard)

[__avd]

>Is there anyway to incorporate the spreadsheet into a VS 2008 VB project so that I can use the "Publish" facility to distribute updated versions of the spreadsheet from a web page

Add spreadsheet document into your VB.NET project and set following properties of spreadsheet file.

1. Build Action=Content
2. Copy To Output Directory = Copy Always
3. Set URL - "Where will be the application check for the update".