Cross Checking
 

All:

I know this is not a solely excel question, it is more of a general
question, but some of you out there might know the answer: I have a folder
with 100s of PDF files and i have an excel spread sheet sheet of a list of
files names. I need to check my excel spreadsheet aganst the folder if I
have those files. How do I do it in a faster way instead of using " Search"
in the folder? Thanks in advance.

Cross Checking
 

I would pull a list of of the PDF files to the sheet with the PDF filenames and
compare the two columns in Excel.

To compare the two columns see this post by Pete U_K

http://tinyurl.com/ywjj39

To get the PDF filenames to the sheet......................

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:25:03 -0800, alish
wrote:

All:

I know this is not a solely excel question, it is more of a general
question, but some of you out there might know the answer: I have a folder
with 100s of PDF files and i have an excel spread sheet sheet of a list of
files names. I need to check my excel spreadsheet aganst the folder if I
have those files. How do I do it in a faster way instead of using " Search"
in the folder? Thanks in advance.

Cross Checking
 

Thanks a lot, Gord. The site mentioned below
http://support.microsoft.com/default...N-US;q272623&; helped me.

"Gord Dibben" wrote:

I would pull a list of of the PDF files to the sheet with the PDF filenames and
compare the two columns in Excel.

To compare the two columns see this post by Pete U_K

http://tinyurl.com/ywjj39

To get the PDF filenames to the sheet......................

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:25:03 -0800, alish
wrote:

All:

I know this is not a solely excel question, it is more of a general
question, but some of you out there might know the answer: I have a folder
with 100s of PDF files and i have an excel spread sheet sheet of a list of
files names. I need to check my excel spreadsheet aganst the folder if I
have those files. How do I do it in a faster way instead of using " Search"
in the folder? Thanks in advance.