Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross referencing | Excel Worksheet Functions | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
cross validation | Excel Discussion (Misc queries) | |||
Cross-bar Highlight | Excel Discussion (Misc queries) | |||
X=y will not cross 0,0 why | Charts and Charting in Excel |