I am sure at some point in your career you have wished for a command that would allow you to select a list of files in Windows Internet Explorer and somehow put this same list of files into Excel without having to either do screen shots or type in the file names one at a time. Here's how:
In Explorer, highlight one or more files.

Hold down the Shift key, and right-click any of the selected files. (If you fail to hold
down the Shift key, you will not get the context menu shown below.)

When the context menu pops up, left-click Copy As Path. (This appears only when you hold down the Shift key.)
Now open an Excel file and paste in your selection. It should look something like this.

Modify the text as you wish from here. It is much faster to delete the full path than to type it all or make screen shots.
Notes from Cadalyst tip reviewer R.K. McSwain: This is a nice trick that has nothing at all to do with CAD, but we think a lot of CAD users will like it. It is a simple way to copy the filename and path of multiple files into Excel. If you don't want the path, use Find and Replace inside of Excel to get rid of it.
|