Excel Automation - Get subfolders from a folder

by SumanS01
Excel Automation - Get subfolders from a folder

Use Microsoft VBA within Excel to retrieve subfolders from a user-chosen folder. These folder names, along with other attributes, are presented in Excel columns for further manipulation. Useful for manipulating data files automatically. can for used to aggregate data from multiple files in multiple folders into one excel file. Or to extract and save data in one excel into multiple excel files n relevant folders for data updation, distribution

image of username SumanS01 Flag of India Gurgaon , India

About Me

Welcome, and THANK YOU for taking time out to view my profile. I am new to this platform. However, I am not new to independent work. I have worked many many years freelancing in the brick-n-mortar world. Along the way, I have built CREDIBLE EXPERTISE in several areas but the 2 I want to highlight here are MY FAVORITES a) Data manipulation b) Content management a) Data manipulation - MS Office, SPSS - Excel (Complex formula, Macros, PivotTable, VBA etc.) - Analysis, automatic charts - Integration (Excel, Word, PowerPoint, Access, PDF, HTML, CSV, XML) b) full life cycle content management (text & images) - Content acquisition from multiple sources (scan, PDF, DOC, web scraping etc.) - Editing, proofreading, typesetting (based on design standards) - Electronic publishing (Adobe PageMaker, Photoshop, InDesign etc.) - Content delivery - ready-to-publish typeset content HTML, eBook etc. - Designing (books, newsletters, blogs) I am based in India & work across multiple time zones.

NEW FREELANCER!

Tags