Processing Multiple Files

Hi All,

I have an application in which i gets two input from user namely the Config file location and Input file Location.These values are stored as TextBox values.

Later when i click the process button,the files are been processed.
Currently it process only one file...as the user select the Input file as Filename rather than the Folder name....

Now i have a requirement in which user just select the InputFile Folder and all files under it with extension .csv are processed one by one.

The codes for the Steps are given below.

Please Login or Register  to view this content.

The workbook Open method is as below

Please Login or Register  to view this content.

Please help to call CreateWafermap for each .CSV file in the Folder one by one.
Find the attachment for more information.

Hi

Have a look here: http://www.excelforum.com/tips-and-t...ernatives.html

It should get you on the right track

Can u help me with some sample codes ?

Regards
Ashesh

Hi Kyle,

May i know which of the variable in above code store the Input file Path...
The Createwafer method requires two parameter as input namely the config file and the name of input file

Regards
Ashesh

I've edited my post, I'm a little confused by your set up, seems a little odd - generally you should avoid global variables.

I think this should do what you want?