EOF of excel in vb6
- by Mark
how do i write the code in vb6 in finding the EOF of excel file
can anyone help me?
i try to code this and it works..
---
Dim excelApp as Excel.Application
Dim excelWB as Excel.Workbook
Set excelApp = New Excel.Application
Set excelWB = excelApp.Workbooks.Open("D:\Book1.xls")
Dim xlsRow as Long
Dim EOF as Boolean
xlsRow = 1
Do While (EOF =…