Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Input Question
I am developing a macro which pulls a lot of information out of certai .txt files and does calculations and such. The problem comes i finding which files need to be parsed. There is no consistent fil naming system. All we know is that it is in a specified folder an that the 3rd line of the file will contain a string which the use specifies. Problem: This directory contains approx. 4000 files so we should no attempt to open every file in the entire directory to parse. I was thinking about trying to use the document properties to sif through the files. For example, we do know that the file has to b created on or after a certain date. Is this faster than opening th entire file for output? (I assume it is) Can anyone think of a way to find the required files faster? Also, is there a fast way to get directly to a specific line number i an input file (or specific line/col in a txt file?) Thanks in advance -- prepotenc ----------------------------------------------------------------------- prepotency's Profile: http://www.excelforum.com/member.php...fo&userid=2415 View this thread: http://www.excelforum.com/showthread.php?threadid=38663 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input Box Question | Excel Discussion (Misc queries) | |||
Input Box Question | Excel Discussion (Misc queries) | |||
Extracting data from one xls file and input into another xls file | Excel Discussion (Misc queries) | |||
Input Box Question with Code | Excel Programming | |||
Input box question | Excel Programming |