Headlines News :
Home » » How to list files in a directory to worksheet in Excel?

How to list files in a directory to worksheet in Excel?

Written By Sambasivarao on Friday, March 28, 2014 | Friday, March 28, 2014

How to list files in a directory to worksheet in Excel?
If you want to generate a list of files in a directory or list files in a folder in a worksheet, you can process the following ways to get a list of files from a directory in worksheet quickly.
Get a list of files in worksheet by using a web browser;
Too many steps, it's not a handy trick.
Using VBA to list files of a folder in a worksheet;
Too complicated, need to know VBA.
Using Web Browser
If you want to list files in a folder by using the web browser, you should make sure you have one of the web browsers (Firefox, Opera and Google Chrome) installed in your computer. Supposing you need to list files of following folder (list files in worksheet) in worksheet, see screenshot: (It’s applicable in Windows XP, Windows Vista and Windows 7. )

How to list files in a directory to worksheet in Excel?: "How to list files in a directory to worksheet in Excel?"
Share this article :

0 comments:

Speak up your mind

Tell us what you're thinking... !

Page views

Blog Archive

 

Proudly powered by Blogger
Copyright © 2011. Useful One! - All Rights Reserved
Template Design by Creating Website Published by Mas Template