I was able to find a few different threads that talk about using Excel in VB.net, but none seem to help me. Here is what I'm trying to do...
I do not want the standard excel toolbar to be usable. I have a form that opens an excel file with a WebBrowswer control. This works. I also have my own toolstrip in the window. When the window opens, only the excel workbook opens. This is perfect. I do not want the user to be able to use any excel buttons. Instead, I want my own "Save" and "Print" buttons. My question... Once excel is opened within this WebBrowser, how can I read the data from within? All the code snipets I found have Excel opening as an application. Is there a way to simply read/write data from an excel file that is already open? Or is there a way to open the file using GetObject and then have that file viewable inside the WebBrowser?
This program will be a "middle-man" between a SQL database and Excel. I have decided to take this route since EVERYONE under the sun knows how to use Excel, and not everyone will understand the simplicity of a datagrid. This sounds stupid, but it is so much easier than training a few hundred people on how to use some new set of software.
Any help is much appreciated!