Getting File Name from a folder.

Question

I want to get the file name from a folder using excel 2007 macros. Or I need to list all the files which are belonging inside the folder. Using excel 2007 macros.

Vijaya Kadiyala · Answer

Hi Check out the below link http://www.excelguru.ca/node/48 Thanks -- Vijaya Kadiyala

Bechir Bejaoui · Answer

If you're creating an Excel add in within C# project Visual tool for office then this code could be helpful it stocks all file names within a list List list = new List (); DirectoryInfo dInfo = new DirectoryInfo(@c:\..........); FileInfo[] FilesList = dInfo.GetFiles(); foreach(FileInfo fi in FilesList) { list.add( fi.Name); }