Is there a specific version of VS 2005 or add on to get this interop service?

Hello Folks, I would like to open an excel and app with visual studio 2005 without using COM. It seems like I should be able do this with the Microsoft.Office.Tools.Excel. It seems like I should be able to open an excel application like I could with Microsoft Excel 11.0 Object Library. I don't want to use the Microsot Excel Oject Libaray because when I try to use it with Microsoft.Office.Tools classes I get a lot if InvalidCastExceptions like when I try to set a Microsoft.Office.Tools.Excel.Workbook = to an Excel.Workbook. Is there a Microsoft.Office.Tools.Excel.Workbook method equivalent to Excel.Worbooks.open("c:/myxl.xls")? It seems strange that we have save and save as in Microsoft.office.Tools.excel.workbook but no open. Also, I cannot seem to add a reference to microsoft.interop.office how can I add a refrence to this if I need to. Please help. This is driving me nuts.

On a data grid is there a way to set the current row number? For example if I know that the black pointer on the left is pointing at current row index 10 and I want the current row to be 11 how do I set it? DataGridView1.CurrentRow.Index is read only.

Thank you so much.

What is the property or method that returns the row that the > pointer on the left hand side of the DataGridView? For example if a user clicks on a row the pointer moves to that row. Then if the user clicks a button to the side of the data grid view I want to know what row the > is pointing to.

How do you select the row that has the ">" pointer on it on the DataGridView? I guess i am looking for the current row or the active row or the row that has focus.

Thanks but where is this sort mode propery? I can't find on datagridview control.

Hello All, I was just wondering if anyone knew how to disable the sorting on data grid columns. I don't want my end users to click the column headers and sort the data. Is there a proerty to set? Any help would be greatly appreciated.

I would like to consume a wevbserice with VB.NET, but I would like to set the URL dynamically because the host for the service might change. I can set the URL be editing the webrefrence but I can not seem to change it programmatically. I have created a reference to MyService private service = new MyService.Service I have tried service.Url = userInputUrl but when I try to compile I get a lot of errors like This is not a member of MyService. Any ideas.

I am trying to read a simple text file using the following code. Dim objReader As StreamReader Dim path As String path = Me.filePath & "app.dat" Try objReader = New StreamReader(path) objReader.ReadToEnd() Me.DBUserID = objReader.ReadLine() Me.DBPassword = objReader.ReadLine() Me.DBServer = objReader.ReadLine() Me.webserviceURL = objReader.ReadLine() objReader.Close() Catch Ex As Exception MessageBox.Show("Cannot Read File:" & Me.filePath & " " & Ex.Message & Ex.StackTrace & Ex.Source) End Try Seems like it should work but i get a nasty exception that I do not understand. "Request for the permission type 'System.Security.Premission.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. I have permissions to read or write any file I want in this folder. "C:/myprog/app.dat." What am I doing wrong and what do I need to do to fix it. I am using Visual Studio 2005 if that helps.