Open Workbook With VB .NET

[garfield185]

Hi everybody.
I opened a thread some days ago because I was trying to break all the links a workbook could have with a program developed on VB.NET.
I received an answer but I couldn't try that yet, because I just can't open any workbook, the error I get says that "The server returned an error".
I have been looking on different forums, searching the internet, there are different ways to open a file, but it seems impossible to me.

First of all, I included the reference to Excel...
"Microsoft Excel 11.0 Object library", I'm working with Office 2003.
Then, I use this code, for example:

Please Login or Register  to view this content.

The error I get says (I'll translate it, but I suppose you'll get it)
"Exception not controlled type: System.Runtime.InteropServices.COMException on Microsoft.visualbasic.dll
Additional information: Server launched an exception

Thanks a lot!!

[dominicb]

Good evening garfield185

I received an answer but I couldn't try that yet, because I just can't open any workbook, the error I get says that "The server returned an error".

Next time you post code on this forum please try and remember to add code tags - use the "#" button above the post entry window. I've done it for you on this occasion.

I usually use this code in VB.Net to open a file along with it's Windows' registered default viewer (in this instance an Excel workbook and Excel) :

Please Login or Register  to view this content.

HTH

DominicB

[stevemannar]

Please Login or Register  to view this content.

full source .. Open and read excel worksheet from excel

Steve