Page 1 of 1

[Solved] Coping titles of folders

PostPosted: Sun May 22, 2011 9:40 pm
by bre_pat_2
I need to make a directory of my embroidery designs. there are several hundred of them and I was hoping to just copy and paste the names of the folders on a spreadsheet and then do the same with the subcatagories. Unfortunatly it is not working as I had hoped. It will not paste to a spreadsheet and when I try pasting it to text document it comes up with a bunch of jibberish and it will not allow me to paste special. Any suggestions???

Re: coping titles of folders

PostPosted: Sun May 22, 2011 10:03 pm
by aqualung
Hello and welcome to the forum!

Can you upload a copy of the file containing the data you want to paste into your spreadsheet?

See the tutorial on uploading a file to the forum: viewtopic.php?f=74&t=8289

Re: Coping titles of folders

PostPosted: Mon May 23, 2011 12:56 am
by Bill
If you're trying to create a list of several folder names, you first need to create a text file which has a list of the folder names, then copy the list from the text file to Calc. The list can't be copied directly using Windows Explorer. The free file manager Free Commander has a command "Folder > Make folder list..." which will create such a text file. Alternatively, you can use the command line to create the text file. In Vista, click the start button and type "cmd.exe" in the Start Search box and press ENTER to open a cmd window. Use the "cd" command to navigate to the directory containing the folders, then use the command "dir /ad >list.txt" to create the text file named "list.txt".

Edit: I've found a workaround that will allow you to paste folder titles in Calc without having to create an intermediate text file. In Windows Explorer, select all of the folders whose names you want to copy, then hold down the SHIFT key, right-click the selected folders and select "Copy as path" on the context menu. You can then paste the copied paths in Calc and use Find and Replace to remove everything except the folder name from the paths.

Re: Coping titles of folders

PostPosted: Mon May 23, 2011 7:41 am
by aqualung
Bill's suggestion sounds excellent.

Bren, did that answer your question? Are you sure that you want your information to be in a Calc spreadsheet, or would a numbered list or a table in Writer be easier?

If your question has been answered, please go back to your first post, click on the EDIT button and insert [SOLVED] before the title.

Re: Coping titles of folders

PostPosted: Mon May 23, 2011 4:45 pm
by JohnV
This post presented an interesting programing challenge so I undertook it.

The macro is posted here. Does the job in about half a second. See below for the options available.

If you don't know how to use a macro found here see the link below. If you still need help just ask.

How do I turn a folder into a file using OpenOffice?

PostPosted: Sun Sep 08, 2013 4:21 am
by Writer21593
I'm new to this program, and I was wondering how to create a file out of a folder, from a rich text document from my desktop. I'm submitting to publishers who require it, done that way. How do I this? Can someone help me with this. Thank you.

Re: [Solved] Coping titles of folders

PostPosted: Sun Sep 08, 2013 12:36 pm
by Hagar Delest
Have you tried the macro???

Re: [Solved] Coping titles of folders

PostPosted: Wed Aug 23, 2017 8:19 am
by v3locim
I would suggest to try "Long Path Tool" program.