Hey Guys,

Let me explain what I am trying to achieve:

I've multiple excel workbooks in a folder. I've to do same task in all of the work books.

Running the same script from Visual Basic Editor for each & every excel work book is very tedious.

How can I run the VBA code for every workbooks in a directory?

Suppose pass a parameter as folder name with path and the VBA code executes for every excel work book present there.

Is this possible? While surfing I found that we can use Visual Basic Script in such cases, I dont have any idea to do this,
please explain.

Thank You!!!