Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|autofill formulas using macro||8||54|
|multiple unique values in different columns||15||36|
|Creating a script to paste in data from series of spreadsheets into one||11||15|
|Need VBA to color cell if 1st three numbers in Column C of Sheet1 match any of the numbers in Column A on Sheet2||22||48|
Join the community of 500,000 technology professionals and ask your questions.