Re: Search non-empty rows, compare text
- From: "Jim Cone" <jim.coneXXX@xxxxxxxxxx>
- Date: Sun, 26 Nov 2006 19:50:36 -0800
You can't have two files with the same name in a folder.
So there is no benefit to including the file path in your comparison.
You would have to check file attributes to attempt to determine
if two identically named files are not identical.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"JustinP" <justin.poole@xxxxxxxxx>
wrote in message
I'm working on a data register that I want to be able to update with
new data in a folder and its subfolders. I am at the stage where it
searches the subfolders for certain types of files and puts the
information in a few rows (filename, filetype, filepath, date modified,
etc). However, at the moment it assumes a new spreadsheet as it starts
putting data in the second row.
What I need next is take the filename and filepath and compare it with
the data that is already in the spreadsheet. If it doesn't exist, find
the next blank row and put it in. The problem is that I need it to
compare two columns at on each row. As an example:
A B
FILENAME FILEPATH
1 Widget C:\temp
Let's say it came across another file called Widget but in the
C:\Windows folder. This would need to be recorded as it is not the same
file. What is the easiest way to ask:
If (inFileN & inFileP = A1 & B1) Then....
Any ideas?
.
- Follow-Ups:
- Re: Search non-empty rows, compare text
- From: JustinP
- Re: Search non-empty rows, compare text
- References:
- Search non-empty rows, compare text
- From: JustinP
- Search non-empty rows, compare text
- Prev by Date: Re: VBA script on document open or close
- Next by Date: Re: Excel Solver with VB
- Previous by thread: Search non-empty rows, compare text
- Next by thread: Re: Search non-empty rows, compare text
- Index(es):
Relevant Pages
|
