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
|Excel VBA - Returning results from batch file||9||65|
|How to change the following 2nd comma in each line to a tilde (~) in Excel 2016?||6||42|
|SUMIFS with a criteria that could be in multiple rows||21||31|
|Sum iF based on a null cell||11||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!