Running macros for a number of files in a directory

[bhanware]

I have some tab delimited text files.
I have recorded a macro for file operation in excel.
But I have to open each file and run macro for it and then save it.
Is there any method by which I can run the macro for all the files in a folder and save them.

 

[Harvey]

you can use the Workbook.Open command to open the files one by one before running your macro.

 

[bhanware]

I have some files in a folder say 100. I have to perform some operation in each file. Now I don't want to open each file, running the macro and save it. Is there anything like batch processing for all files sothat the macro opens each file, performs operations and save them.

 

[Harvey]

With the Dir command, you can get a list of all files in the directory.

    a = Dir("*.xls")
    While a <> ""
        Debug.Print a
        a = Dir
    Wend

you can perform any actions with the file name, like replacing debug.print with workbooks.open(a)

hope this helps.