#1
|
|||
|
|||
I want to print a list of sub-folders within a folder.
Hi, I have a folder in Excel and within that folder are approx 400 folders containing photographs. Each of these subfolders is named and I want to print a list of these names to compare with another file to see if any are missing. I can't see how to print off a list without doing a screen print, which will list only about 25 per page. Is there a quicker way of doing it please? |
#2
|
|||
|
|||
Anyway, attached is an excel workbook I created many years ago - probably it gives you some ideas. You simply copy it into folder you want to read, and enter file extension you want to be listed from current folder and it's subfolders. |
#3
|
|||
|
|||
I want to print a list of sub-folders within a folder.
Hi
Thank you for your prompt reply but I don't understand how to do this. |
#4
|
|||
|
|||
To do what?
To check how the example file works: 1. Copy the file into some folder and open it. Probably you have to allow make changes, to run code, etc. Also, it will be best when you save it in xlsm format (the file was created when MS Excel97 was top thing). 2. Into cell B1, enter file extension for file types you want to be displayed (Laiend: ). In cell A2, the folder where the file is copied into, the address of this folder is displayed, and below it, all files with extension you set before, which are found in this folder, are displayed. In C2, D2, ... are all subfolders of folder in A2 displayed, and respectively below them all files with set extension in every of those subfolders are displayed. To examine how this works in depth: Open the example file and press Alt + F11 - VBA Project window is activated. There are 3 User Defined Functions (UDF) defined. Those functions are used in formulas on Sheet1, to display folder and files according to extension you did set on Sheet1. Study formulas on Sheet1, and VBA code of UDF's, to understand how this works. |
#5
|
||||
|
||||
Alternatively, Karen's Directory Printer is extremely powerful and versatile.
|
#6
|
|||
|
|||
I want to print a list of sub-folders within a folder.
Thank you both for your replies and assistance, much appreciated.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving messages to folders by typing folder name | fuzzybunny | Outlook | 0 | 01-26-2019 04:47 PM |
Task list checkboxes appear solid black when I print list | mechitar | Outlook | 0 | 10-24-2018 09:06 AM |
Finding a folder in the Inbox list from a proprietary list | kovenna | Outlook | 0 | 05-09-2017 06:18 AM |
Lost a folder in my Mail Folders! ... Update: Found! | Stjamesg8 | Outlook | 0 | 06-08-2015 09:51 AM |
[OL2010] Creating a search folder with folders belonging to other POP3 Account | balubeto | Outlook | 0 | 01-07-2011 02:07 AM |