Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings !
I have over 50,000 *.CHK files in seven FOUND.00n folders. These represent the entire contents of my "My Pictures" Folder. Most of them have been backed up. So I wish to run through the first 64 characters of each of my backed-up files, and compare them inturn with the first 64 characters of those .CHK files. If I get a match, then I propose to compare the entire content of the .CHK file with the equivalent length of the backed-up file. If I get a match on this, then I am happy to assume that I have that file backed up, and can then delete the .CHK file. Now my question! Would it be "better" to load those 64 characters from the .CHK files into separate rows in the spreadsheet, or to load them directly into an array in VBA ? If the former (into Cells), then I would also save into the same Row the file name, size and path, to enable me to operate on those files. -- Regards Robin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with cells Array | Excel Discussion (Misc queries) | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Can a UDF be used on an array of cells? | Excel Worksheet Functions | |||
Count if array contains cells of a certain value | Excel Worksheet Functions | |||
How do I sum an array of cells, even if some of them are #N/A | Excel Discussion (Misc queries) |