cut and paste filenames from explorer window

[david]

How can I cut and paste a filename from an explorer window
into an excel spreadsheet.

 

[Andy B]

david

Select the file in Explorer, then click on it again - as if you're about to
rename it. That allows you to right-click and Copy and left-click and Paste
in Excel.

Andy.

 

[Mathew P Bennett]

Hi david
You could try this in a cell on your worksheet

=cell("filename")
(this is atually "filename") ie type "filename"

Mathew

 

[Dave Peterson]

There are a lot of shareware/freeware options that allow you to grab the file
list from windows explorer.

I search www.shareware.com and found this one (untried, though):

http://download.com.com/3000-2248-7706254.html

Another way is to get to a DOS prompt and traverse to your folder.

Then type:

dir > dir.txt

Then inside excel, file|open that dir.txt. You'll see the data import wizard
and you can parse the file into nice columns.