raocarlos600
3/5/2018 - 8:15 AM

abrir excel desde vb y bucle para recorrerlo y rango de filas del excel

openExcel
content_copyfile_download
Dim Aplicacion As Excel.Application
Dim Libro As Excel.Workbook
Dim Hoja As Excel.Worksheet

Aplicacion = New Excel.Application
Libro = Aplicacion.Workbooks.Open("C:\Test.xlsx")
Hoja = Libro.Worksheets(1)
 
 Dim FinalRow As Integer
 FinalRow = Hoja.Range("B30").End(Excel.XlDirection.xlUp).Row
  For i = 2 To FinalRow
      
  Next i