Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I always use this to find the length of a text file but isn't there a
better way? While (EOF(1) < True) Input #1, ' text count = count + 1 Wend Thanks, -- Dan |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Use the LOF command?
-- Regards, Tom Ogilvy "Dan R." wrote: I always use this to find the length of a text file but isn't there a better way? While (EOF(1) < True) Input #1, ' text count = count + 1 Wend Thanks, -- Dan |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I always use this to find the length of a text file but isn't there a
better way? While (EOF(1) < True) Input #1, ' text count = count + 1 Wend Count = FileLen("<<path to your file") Rick |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think LOF returns the file size in bytes... but I could be wrong...
Thanks, -- Dan |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That worked... thanks Rick.
-- Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving a worksheet as . prn text file - record length | Excel Discussion (Misc queries) | |||
Fixed length text file | Excel Discussion (Misc queries) | |||
Find and Length | Excel Worksheet Functions | |||
Find Folder Path + file Name Length and Insert into Spreadsheet | Excel Programming | |||
find a text in a file name | Excel Programming |