steveosmith

Am using the AXWebbrowser component in .net to open an excel workbook. How do I prevent the "What to you want to do with this, open or save?" message when the file loads? I know my user can select the Do not show this again option, but I want to suppress it the first time as well. Anyone have any thoughts?

Hi all, Just stumbled upon this forum. Anticipate spending MANY hours here. Anyway, I'm having problems closing an Excel workbook from within my vb.net app. I use a web browser to host an instance of Excel, which I'm accessing thru the PIA's. To over-symplify, I open a file in the web browser, set an instalnce of Excel to equal that file, then maniuplate it thru my Excel instance. I can open files, add or remove pages, edit cells, etc., but I can't close a file. Seems like I could use: xlapp.ActiveWorkbook.Close The code runs, but the workbook still shows in my web browser. And if I loop thru every workbook in xlapp, it's still there as well. I've also tried: xlApp.ActiveWindow.Close but get a type mismatch error. I can't imagine this would be too hard, or else I'd be seeing other posts referring to the same thing. Anyone have an idea of what I'm missing? Thanks in advance, Steve.