How can I cut and paste a filename from an explorer window into an excel spreadsheet.
D david Sep 16, 2003 #1 How can I cut and paste a filename from an explorer window into an excel spreadsheet.
A Andy B Sep 16, 2003 #2 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.
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.
M Mathew P Bennett Sep 16, 2003 #3 Hi david You could try this in a cell on your worksheet =cell("filename") (this is atually "filename") ie type "filename" Mathew
Hi david You could try this in a cell on your worksheet =cell("filename") (this is atually "filename") ie type "filename" Mathew
D Dave Peterson Sep 17, 2003 #4 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.
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.
