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)

>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".

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.