If you have to deal with hundreds of thousands of documents to sort out, is there a sense of powerlessness, don't worry. The System Home tells you how to use the PrintFolder and Excel software to create a directory of documents containing open links to greatly improve the efficiency of document usage and management. Nowadays, the capacity of computer hard disks is getting bigger and bigger, and more and more kinds of documents have been downloaded and used. Over time, it will inevitably be difficult to find some important documents. Faced with thousands of personal documents, even people with the best memory can not find the documents they need urgently every time. Through the file search function that comes with the Windows operating system, although the related document search can be performed based on the file name, type size, and text, etc., the search result is not easy to save, even if the same document is to be searched next time, it is still necessary to re-run. Searching is a bit of a waste of time. In fact, with the help of PrintFolder and Excel software, you can quickly create a document directory containing open links for a hard disk partition or folder after a few simple operations, which not only facilitates us to understand the overall distribution of various documents. Situation, but also can save some document search time, improve the efficiency of document usage and management. First, get the document information under the target partition can extract the information of the name, type, size and other information of all files in the specified partition or folder, here is the PrintFolder Pro Chinese version (download address: http://www.onlinedown .net/soft/3577.htm), install and run the software, first open the "Options" tab at the top left, click the "Edit" button, open the "Advanced" dialog box, in the "Include files Under the Information tab, select the file attributes to be extracted, such as the full file name (ie file name + extension, %NAME), file name (%FNAM), file type (ie file extension, %FEXT), file. Path (%PATH), file size (%SIZE), etc., add the file creation date (%DATE) under the "File timestamp> label. In order to facilitate the creation of a hyperlink to access the file later, you also need to combine the file path and file name. Extension into a new data item. %PATH%NAME is added to the example, pay attention to the middle with “|
& rdquo; to separate, in order to facilitate text sorting in Excel, you can also enter the string %FNAM| directly in the "example" text box
%FEXT|
%SIZE|
%DATE|
%PATH%NAME (Figure 1). Click the “Exclude” button to open the &Exquo;Exclude” dialog box to set the file type or file (folder) name to be excluded from the search; click the “More Options” button to also access the folder, File and list related output settings, here check the "Ignore empty folder", "<;full path" and "by KB" unit, etc., that is, to ignore empty folders in the search results The full path shows where all files are stored, and the size of the file is displayed in kilobytes. Go back to the "Navigator" tab, select the partition or folder where you want to create the document link table, select the E drive here; enter *.doc;*.xls;*.ppt in the search file type to find three commonly used Office document type, note that the different document types are separated by a semicolon in the half-width state; check the "recursive subfolders" in the lower left and "subfolders of all levels". After clicking the “OK" button, the system will soon help us search for the specified attribute values of all related documents in the partition, and automatically "“|
& rdquo; symbol separation (Figure 2). Second, create a document link table in Excel In the search results box on the right side of the PrintFolder software, right-click to open the shortcut menu, and then execute the “Select All” "Copy” command to copy the above search results; then open Excel2007 , paste all of them into a new worksheet, then select the column data, execute the "Data - Columns" command, through the "Text Sort Wizard", select the text separator for "ldquo;"
”, the individual document attribute values are displayed separately (Figure 3). Set the corresponding Excel header according to the contents of the table. If you want to make the document directory search more convenient, you can select the entire data area and sort the documents by the specified attribute values. Here, the file type is used as the main keyword, and the creation date is the secondary keyword for sorting. Insert the HYPERLINK function in the F column. The function of this function is to create a shortcut or link to open a document stored on the local hard disk, LAN server or Internet. The Link_location parameter indicates the file path, which corresponds to the G column. In the content, the Friendly_name parameter indicates the name of the hyperlink, which is set to “Open”, and copy the function to the entire column of cells to complete the creation of the document link (Figure 4). After the above simple operation in Excel, we will quickly get the document directory of the specified partition. All the document names are arranged in order according to the specified keywords, which is convenient to find; each document name contains an access link. Opening is also very fast. Third, through the batch processing command to quickly delete useless files in the process of using the document link table to view the use of various documents, it is inevitable to find some recurring or useless documents, open each folder one by one, of course, you can delete, but manually The efficiency of the operation is really flattering. In fact, we can also use the above document directory, first add a secondary column in front of the file path, set the documents that need to be deleted in batches with the same symbol, such as *; and then sort by the primary column & quo; , you can immediately filter out the documents that need to be deleted distributed in different files (Figure 5). To open a temporary worksheet, first enter the open symbol @echo off of the batch command in cell A1, enter the forced delete command del /f /s /q in cell A2, and copy it to the other cells in column A. The /f parameter indicates that the read-only file is forcibly deleted; the /s parameter indicates that the specified file is deleted from all subfolders; the /q parameter indicates the quiet mode, that is, the confirmation operation is not required when deleting. Next, copy and paste the file path information that needs to be deleted into the B column cell at the beginning of the B2 cell. Finally, copy all the contents of the worksheet and paste it into a Notepad document, execute the "File → Save As" command to save the text content to a Windows batch file with the extension bat ( Image 6). Double-click on the file to quickly delete all the unwanted files in batches. If you want to copy important documents distributed in different folders to the same folder for backup, you only need to change the delete command del to copy command copy, the parameter is adjusted to /y, set the backup folder in column C, refer to The method for generating the batch file described above can also implement a fast batch backup operation of the document. This article comes from [System Home] www.xp85.com