How to use List Names.
|
Note
»
Macros can't be undone. Save your work before running any macro. If the macro doesn't function as you expected simply close your workbook WITHOUT saving. Then reopen the workbook and everything should be the same as before you ran the macro.
|
Step One
»
Open List_Names_v1-0.xls. (If you are reading this then the workbook should already be open)
NOTE: When opening the workbook you may or may not have been prompted to disable/enable macros. You will need to enable macros for the macro work. If you clicked disable when opening this workbook, simply close this workbook and reopen it enabling macros.
|
Step Two
»
On the "Main" worksheet click "Browse" and select the folder you want to generate a list of file and/or folder names
|
Step Three
»
Under "Select Options" select "List Folder Names","List File Names", or "List File and "Folder Names"
|
Step Four (Optional)
»
Under "Select Options" select "Include Full Path" if you want to see the full path for the names in the list, and/or select "Include Subfolders" to generate the names of the files/folders in any subfolders of the path you selected in step 2.
|
Step Five
»
Click "Start" and the macro will generate the list of names. The list of names will be listed on the "Results" worksheet
|
The macro doesn't run, What is wrong?
»
If the macro doesn't even start it could be because the security settings in Excel are too restrictive. I suggest setting the macro security on medium. This will prompt you to choose between enabling and disabling macros in a workbook. To see your settings or change your current settings click Tools-->Macro-->Security. Look under the Security Level tab, you can change the setting from low, medium, or high. If you choose high this will always disable macros and Worksheet Sort will not run.
|
Download
»
The trial version of List Names is limited to listing up to 50 file and/or folder names.
Click here to download a trial version of List Names v1.1
|
Purchase
|
|
|
»
The trial version of List Names is limited to listing up to 50 file and/or folder names. If you would like an unrestricted version the cost is $9.95 USD.
The software is available by download only. After the payment process is complete, you will receive a serial number.
|
|
