Search non-empty rows, compare text
 

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?

Search non-empty rows, compare text
 

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"
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?

Search non-empty rows, compare text
 

I meant two files with the same name in different folders, like:

A B
FILENAME FILEPATH
1 Widget.txt C:\temp
2 Widget.txt C:\Windows



Jim Cone wrote:
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

Search non-empty rows, compare text
 

I'm still hoping someone can help me here...

JustinP wrote:

I meant two files with the same name in different folders, like:

A B
FILENAME FILEPATH
1 Widget.txt C:\temp
2 Widget.txt C:\Windows



Jim Cone wrote:
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