Hi, how do I use the EOF function with an Excel spreadsheet? I'm thinking that the EOF needs a file number. But in my code below, I don't have a file number. What do I need to do? Any links, code, info available? Thanks.
Dim app As excel.Application Dim book As excel.Workbook Dim sheet As excel.Worksheet Set app = New excel.Application zza = "C:\ ... Data.xls" Set book = app.Workbooks.Open(zza) Set sheet = book.Worksheets(1) (INSERT EOF CODE HERE.) Set sheet = Nothing book.Close SaveChanges:=True Set book = Nothing app.Quit Set app = Nothing