Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
 



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

All times are GMT -7. The time now is 08:01 AM.


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