Hi All,

I have a question regarding opening and closing files in a Windows Form written in VB.NET using VS 2003.

Currently my program automatically opens a folder C:\Upload\Folder1 and opens the Excel file that is in that folder (file1.xls). It works with this file correctly and closes it correctly.

However, Now I have a requirement to cycle through the Upload folder going into each subfolder i.e. Folder2, Folder3 etc... And in turn read each excel sheet that is in there.

For example I want my program to do the following:
Open Folder1
Read File1.xls
Open Folder2
Read File2.xls
Open Folder3
Read File3.xls

and continue going through all the folders until there are no more folders in C:\Upload

How would I go about coding this?

Thanks for your help, it is much appreciated.
Shades7_99

The System.IO namespace is what you will need to use and, more specifcally, the File, FileInfo and DirectoryInfo methods contained within it.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429