Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2020, 04:24 AM
Joanne Joanne is offline I want to print a list of sub-folders within a folder. Windows 7 32bit I want to print a list of sub-folders within a folder. Office 2010 32bit
Advanced Beginner
I want to print a list of sub-folders within a folder.
 
Join Date: Jul 2013
Posts: 40
Joanne is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 07-07-2020, 05:15 AM
ArviLaanemets ArviLaanemets is offline I want to print a list of sub-folders within a folder. Windows 8 I want to print a list of sub-folders within a folder. Office 2016
Expert
 
Join Date: May 2017
Posts: 575
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

Quote:
Originally Posted by Joanne View Post
Hi, I have a folder in Excel...


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.
Attached Files
File Type: xls GetFolderGetFile.xls (50.5 KB, 3 views)
Reply With Quote
  #3  
Old 07-08-2020, 01:22 AM
Joanne Joanne is offline I want to print a list of sub-folders within a folder. Windows 7 32bit I want to print a list of sub-folders within a folder. Office 2010 32bit
Advanced Beginner
I want to print a list of sub-folders within a folder.
 
Join Date: Jul 2013
Posts: 40
Joanne is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 07-08-2020, 03:06 AM
ArviLaanemets ArviLaanemets is offline I want to print a list of sub-folders within a folder. Windows 8 I want to print a list of sub-folders within a folder. Office 2016
Expert
 
Join Date: May 2017
Posts: 575
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

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.
Reply With Quote
  #5  
Old 07-08-2020, 05:23 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline I want to print a list of sub-folders within a folder. Windows 10 I want to print a list of sub-folders within a folder. Office 2010
Novice
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default

Alternatively, Karen's Directory Printer is extremely powerful and versatile.
Reply With Quote
  #6  
Old 07-09-2020, 02:17 AM
Joanne Joanne is offline I want to print a list of sub-folders within a folder. Windows 7 32bit I want to print a list of sub-folders within a folder. Office 2010 32bit
Advanced Beginner
I want to print a list of sub-folders within a folder.
 
Join Date: Jul 2013
Posts: 40
Joanne is on a distinguished road
Default I want to print a list of sub-folders within a folder.

Thank you both for your replies and assistance, much appreciated.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft