Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.find performance
my project involves parsing large number of excel files. and looking for
keywords in each file, I am wondering if this could be a performace issue, to call the Find function requently. the other approach i've seen is to get the contents into an array ans work off that array to gain efficiency. any experience to share? thanks. -- epr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.find performance
The FIND function from my experience works very efficiently. The functions
to load an array I don't think are as efficient and will use lots of memory. Depending on how you computer is set up when large amount of memory is used the pages get swapped onto disk when they aren't used. The swapping process if very inefficient. There are also ways of reading an excel file without opening the file which may increase the speed of the code. This method uses database commands to look at the file. When people have large databases that are shared you don't want everybody trying to open these files and they can't be written when they are opened. I never compared the speed of accessing opened excel files with closed excel files. "epr" wrote: my project involves parsing large number of excel files. and looking for keywords in each file, I am wondering if this could be a performace issue, to call the Find function requently. the other approach i've seen is to get the contents into an array ans work off that array to gain efficiency. any experience to share? thanks. -- epr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find End in Undefined Range Select Range Trim | Excel Programming | |||
ADO - recordset find performance slow | Excel Programming | |||
Find the POSITION IN A RANGE of text in a string that matches value(s) in a range | Excel Programming | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Range.Delete and Range.Resize.Name performance issues | Excel Programming |