Imports Excel = Microsoft.Office.Interop.Excel Public Sub WhatsMyVal() Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet xlApp = New Excel.Application xlWorkBook = xlApp.Workbooks.Add(TextBox1.Text) xlWorkSheet = xlWorkBook.Sheets("sheet1") Dim myString = xlWorkSheet.Range("A1").Value.ToString MsgBox("this is myString: " & myString) End Sub
|Help with copying data from all data elements from file2 to file1 based on matching values including additional records in file2 using VB,NET||10||37|
|In Excel 2007 in data validation list, why does Excel perform a calculation when entering 2: 1 in the data validation list and how should I change this so no calculation is performed?||2||23|
|Formula to Compare 2 Excel Worksheets If data in Worksheet 1 matches data in Worksheet 2 then copy that to Worksheet 3||9||28|
|Help with sending PDF contents to server when Hyperlink Clicked.||5||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!