Help Required
-
Nowhere else to ask, so here goes. I have a set of files in a folder, is there a way to pick up the names and paste them into an Excel spreadsheet?
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
in command prompt dir>c:\filename.txt then copy into excel You will have to get rid of the dates somehow, a vb macro perhaps? :laugh:
-
Nowhere else to ask, so here goes. I have a set of files in a folder, is there a way to pick up the names and paste them into an Excel spreadsheet?
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
TommyTomToms answer is [edit]probablydefinately more useful, but if you need to copy-and-paste from the dos window: 1. Right click 2. Select Mark 3.Drag a rectangle over the area you want to copy 4. hit "Enter" (not return). The area selected is copied into the clipboard.
CCC solved so far: 2 (including a Hard One!)
-
in command prompt dir>c:\filename.txt then copy into excel You will have to get rid of the dates somehow, a vb macro perhaps? :laugh:
/w
xacc.ide
IronScheme - 1.0 beta 4 - out now!
((λ (x) `(,x ',x)) '(λ (x) `(,x ',x))) The Scheme Programming Language – Fourth Edition -
TommyTomToms answer is [edit]probablydefinately more useful, but if you need to copy-and-paste from the dos window: 1. Right click 2. Select Mark 3.Drag a rectangle over the area you want to copy 4. hit "Enter" (not return). The area selected is copied into the clipboard.
CCC solved so far: 2 (including a Hard One!)
Cool, i didn't know that :thumbsup:
-
TommyTomToms answer is [edit]probablydefinately more useful, but if you need to copy-and-paste from the dos window: 1. Right click 2. Select Mark 3.Drag a rectangle over the area you want to copy 4. hit "Enter" (not return). The area selected is copied into the clipboard.
CCC solved so far: 2 (including a Hard One!)
Thanks guys, Got EXACTLY what I needed! Spot on.
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
-
Nowhere else to ask, so here goes. I have a set of files in a folder, is there a way to pick up the names and paste them into an Excel spreadsheet?
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
Try the SendToX powertoy. When installed, right-click on your files and choose "SendTo >> Clipboard (as name)". Paste into excel - if you don't want the full path, a simple find and replace will help
-
Thanks guys, Got EXACTLY what I needed! Spot on.
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
I find it easier to enable the QuickEdit and Insert modes from the system menu for a command prompt window. Then you just have to select text, right click to copy to clipboard. A second right click will paste text from the clipboard to the command prompt. When you save the change, it prompts whether you want to save the change for the current window or modify the shortcut that launched the window. If you choose the second option, it saves the hassle of doing it every time you open a new window.
-
in command prompt dir>c:\filename.txt then copy into excel You will have to get rid of the dates somehow, a vb macro perhaps? :laugh:
- "dir/b/a-d > 1.txt" - open "1.txt" in notepad - ctrl-a - ctrl-c - paste in Excel
-
/w
xacc.ide
IronScheme - 1.0 beta 4 - out now!
((λ (x) `(,x ',x)) '(λ (x) `(,x ',x))) The Scheme Programming Language – Fourth Editionor /b if desired without path
Personally, I love the idea that Raymond spends his nights posting bad regexs to mailing lists under the pseudonym of Jane Smith. He'd be like a super hero, only more nerdy and less useful. [Trevel]
| FoldWithUs! | sighist | µLaunch - program launcher for server core and hyper-v server -
TommyTomToms answer is [edit]probablydefinately more useful, but if you need to copy-and-paste from the dos window: 1. Right click 2. Select Mark 3.Drag a rectangle over the area you want to copy 4. hit "Enter" (not return). The area selected is copied into the clipboard.
CCC solved so far: 2 (including a Hard One!)
Right-click pastes, and my keyboard has two ENTER keys, no RETURN.
-
Right-click pastes, and my keyboard has two ENTER keys, no RETURN.
The ~ENTER~ is the one on the Key pad.
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
-
Thanks guys, Got EXACTLY what I needed! Spot on.
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
DIR /B For Barebones ;)
Cheers, Vikram. (Cracked not one CCC, but two!)
-
The ~ENTER~ is the one on the Key pad.
------------------------------------ To eat well in England, you should have a breakfast three times a day. W. Somerset Maugham 1925
Yes but they both works in this case.:)
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.