Opening excel workbooks automatically

HI,

I have a folder named "SALES" :-(C:\GRANDVARIATIONS\SALES) in which there are about 30 separate excel workbooks. The first workbook in that folder is named "1st":- (C:\GRANDVARIATIONS\SALES\1st) . Each of those workbooks have a "command button" which runs vba , when clicked .

Now, I'am looking for a vba code which a) OPENS THE FIRST WORKBOOK AT SALES FOLDER b) INITIATES THE COMMAND BUTTON IN THAT WORKBOOK c) WHEN THE FIRST WORKBOOK CLOSES IT AGAIN OPENS THE SECOND WORKBOOK d) REPEATS THE PROCESS UNTIL THE LAST WORKBOOK IN THAT FOLDER.

Thank you

Hi, Richard

Thanks for the reply,

Actually i'am new to VBA codes, i just want to open those workbooks and run the codes in them , i don't need to close them because after running the codes , they close by themselves.

Its just about opening and running the codes in them.

Please do let me know about the codes format for master workbook.

Cheers

@ pjwhitfield

Thank you for the code,

Does it also runs the code in those workbooks?

Cheers