Excel name box

[maurpalmenice (Maurice)]

Found the Solution inside the forum go here:

How to get active cell address from Excel

Hey @Honoka I am using below code for getting cell reference/address but it’s not working and throwing error: Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range Dim s As String Try wb = DirectCast(GetObject(Path),Microsoft.Office.Interop.Excel.Workbook) Catch ex As Exception excel = DirectCast(CreateObject(“Excel.Application”), Micros…