Using Visual Basic - need to access a Excel workbook Cell Programed VB since the early days, and had every thing working great in win 10 VB. Then had to upgrade to Visual Studio 2002, when i upgraded to Win 11 looking for just the code to access one cell on a excel Office 365 workbook... thanks for the help
Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=FullFileName.xlsx;Extended Properties='Excel 12.0;HDR=YES';" Using connection As New OleDbConnection(connectionString) Using command As New OleDbCommand(selectSQL) command.Connection = connection Try connection.Open() Dim singleValue = command.ExecuteScalar() 'you can use singleValue variable now ;) Catch ex As Exception Console.WriteLine(ex.Message) End Try End Using End Using
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)