VBA for multiple workbooks in a directory

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!!!

Hi,

should be possible if you know coding in VBA !

Start to read Dir function inner VBA help …

Hello Marc L,

I think this is also possible using Visual Basic Script. But I am not sure.

Thank You.

VBA code to open multiple files in same folder and perform same macros

Please Login or Register  to view this content.

and another VBA Code To Open Multiple Excel Files;

Please Login or Register  to view this content.

If you want to apply all excel files ( including closed );

Please Login or Register  to view this content.