💼 VBA File & Folder Index Generator — by CA Rahul Kant (Ex-PwC | Former CFO | AICA)

🚀 Instantly Map Every File & Folder in Seconds — Directly Inside Excel.

If you’ve ever struggled to track files across multiple drives, this plug-and-play VBA macro is your new best friend.

Built by CA Rahul Kant, a PwC-trained finance leader and automation enthusiast, this Excel-based tool helps professionals list, link, and open every file inside a chosen folder — recursively — in just one click.

⚙️ What It Does

✅ Prompts you to select any folder or drive
✅ Lists all subfolders & files (recursively)
✅ Auto-creates clickable links to open files
✅ Generates a new Excel sheet every run (timestamped)
✅ Error-free, reusable & production-ready VBA

🧩 Why Professionals Love It

• 📂 Perfect for CFOs, auditors, consultants & MIS teams
• 🧠 No manual file tracking — complete directory map in one sheet
• ⚡ Works with unlimited subfolders — even network drives
• 💾 Zero setup. Just paste, run & save as Macro-Enabled Workbook

🧭 How to Use

1️⃣ Open Excel → Press ALT + F11 → Insert Module → Paste Code
2️⃣ Run ListFilesAndFoldersWithLinks
3️⃣ Select a folder — and watch Excel do the magic
4️⃣ Save your workbook as .xlsm and reuse anytime

🪄 Bonus Tip

Add a one-click “Generate List” button to your Excel ribbon or sheet — ready for daily, weekly, or audit use.

👨‍💼 Author Insight

💰 Product Type

Prompt + VBA Code + User Guide
✅ Plug-and-Play Excel Automation
✅ One-time setup | Lifetime Use

🔗 Get It Now

Turn Excel into your personal file indexer.