How to Extract All File Names, Paths, and Sizes from a Folder in Excel Using VBA

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video, you'll learn how to extract all file names, paths, and sizes from any folder using a simple VBA script in Excel. Whether you're managing a large number of files or just want to automate file data extraction, this tutorial will guide you step-by-step through the process.

By the end, you'll be able to easily pull file information directly into your Excel spreadsheet, saving time and reducing manual effort.

📌 What you'll learn:

How to write VBA code in Excel
Extract file names and paths automatically
Convert file sizes into KB for easy viewing
Automate file management tasks in Excel
This method works for beginners as well as experienced Excel users who want to streamline their workflow.

🔔 Don’t forget to subscribe for more Excel tips and tutorials!

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

#NazimExcel #AdvanceExcel #MISReport #DashboardReport
#ExcelCourse #LearnExcel #Exceltricks #Exceltips #BusinessExcel

[umairzahid]

Very beautiful information and learn. Thanks sir

[munsifkhan]

Sir ager hamri pas istara ka sheet jaisa k ya video may ha aur is ko folder may canvart karna ho to Kasi karingay

[bid]

Hi sir, do you provide billing excel file with customization ?

[ss-rmpo]

sir power query playlist of 20 plus videos banaye ..

[zaheerkhan]

It can be much simpler just by using a one powershell command "GCI" and export the same data in csv.

[manindermanu]

Sir ap ne ek video banie thi.
Kush saal phle. Google chrome main ek extension add karne ki.
Kisi v pehra Graf ko high light kare the wo English to Hindi ho jata tha.
Plese sir share this video.

[manjunatha]

how to solve this column has more than 10 000 unique items. only the first 10 000 unique items are displayed in filter please share solution for this issue

[ThePoet]

Bhai aapke website ko kya ho gyaaa ....traffic ekdm se niche chla gyaaa

[autotechsolutions]

Sir emi calculating excel sheet bana sakte hai kya jaise ki mera emi har mahine 15127 deduct hota hai aur y years ke liye loan hai lekin muze ye nahi pata ki uska intrest kaise calculate kare first to ye problem aa rahi hai aur second ko wo loan reducing hai to uske hisab se har saal mere emi me kitna kam hoga iska excel pe agar aap video bana sakte ho to plz try it will be big help from your side to all of us ❤

[arman]

salam, mere pass ik Data sheet hai jis main taqreeban 200, 000 entries hain, woh data chapterwise hai 1 se 99 tak chapters hain or har chapter main Taqreeban 400 se 8000 tak entries hain, mujhe chapter ke hisab se Data se ik alag files gnerate karni hai jo ke chapter wise sae ho jaye, koi esa VBA code batain jis se yeh kam asani se ho sake, abhi main filhal Privot table se yeh kam kar raha hoon