| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding out File size before opening it
Hi,
I have to go through a lot of excel files to find which ones are for a date. That part works fine I go through the directories open all the files and look inside them. What I need to do now is in VBA find if the file is ZERO length before I have opened it Thanks MarkS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding out File size before opening it
See FileLen function in VBA Help!
Regards, Stefi €˛MarkS€¯ ezt Ć*rta: Hi, I have to go through a lot of excel files to find which ones are for a date. That part works fine I go through the directories open all the files and look inside them. What I need to do now is in VBA find if the file is ZERO length before I have opened it Thanks MarkS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Size a real problem! | Excel Discussion (Misc queries) | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
| Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
