文件名信息抓取.xls

Sheet3 Sheet2 Sheet1 1. Click Run order in Start menu 2. Key in CMD and click OK command. 3. Key in S: and Enter to change the hardware disk. 6. Click right button of the mouse and click the Select All order. Then key enter to copy all the docs information;and then paste them in and txt sheet. press any key to continue to show other dos infromation, and repeat the copy operation until you get all the docs information. Remark: part of the imformation will be repeatable, and you can delete them after pasting in txt sheet. 7. Click Open order in file menu in an Excel to open the txt sheet, selecting the Files type as All Files and select the TXT file you want to open. 8. Click Open in step 7 to enter into this window. Select fixed width and click Next order. 9. Adjust the break line per your need. And click Finish button. And you can get the information as Excel format. 4. Key in cd MAE\Avery\Industrial\Core\Clean Core and Enter to enter into the folder which the drawings are in. 5. Then key in dir /od /p and Enter to show the docs per updated time. 12 times continue step 1 step 2 step 3 step 4 step 5 step 7 step 6 step 8 step 9