I have a web application developed with asp.net, vb.net.
My client wants to have this kind of feature:
When the user clicks on the links to Office files (Excel, Word, Visio), the files are opened based on the user profile, in other words, the files are either open in read-only or in full-mode.
I tried several different solutions which I found on the internet but none of them worked properly or required a lot of configuration.
1) I found a client-side vbscript which allows opening office files. It works ok for for simple html pages but in my application it doesn't work giving me Activex component error. http://support.microsoft.com/support/kb/articles/Q178/2/22.ASP
2) Also, I tried using Microsoft.Office.Core library (for example,
Dim objExcel as New Excel.Application
objExcel.Visible = true
to do the same thing but unfortunately as I discovered, it doesn't allow opening the files on the fly. However, it opens the files for Windows-form application.
3) I installed Office Web component 11 and I tried using it to achieve the same goal but I was unlucky again.
So, is there a way to open Office files in different modes from the web application?
I need clear explanation with some code snippet in vb.net or c# or some scripting language.
May be, someone had the same kind of problem.