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
Bookmarks