Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect excess rows in txt or csv files before opening?
Windows XP Pro SP2
Excel 2002 SP3 I am trying to detect if a txt or csv file has more than 65,536 lines before opening it. I've written this little tidbit for testing: Sub testme() Dim data As String Dim fname As String Dim c As Long fname = "C:\911\_temp\test_data1.csv" Open fname For Input As #1 c = 0 Do Until EOF(1) Line Input #1, data c = c + 1 Loop Close #1 MsgBox c End Sub This works fine on files with less than or equal to 65,536 lines of data. If I try the same code on a file with 65,537 lines or more then Excel locks up. Is there any way around this? Why is Excel crashing? Should I bite the bullet and learn to use Access? Any and all suggestions welcome. Thanks! -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office button, how to remove excess files no longer needed | Excel Discussion (Misc queries) | |||
Additional rows added to spreadsheet when opening text files | Excel Discussion (Misc queries) | |||
How to detect excess rows in txt or csv files before opening? | Excel Programming | |||
How to detect and view more than 65,536 rows when opening a DBF | Excel Programming | |||
opening text files that have more rows than 65536 | Excel Worksheet Functions |