OPENING DIFFERENT WORKBOOKS automatically

[LAVA2]

HI,

I have 100 folders and each folder contains 1 workbook . I am looking for a solution that can open those workbooks simultaneously starting from Works1.xlsx of "works1" folder to Works100.xlsx of "works100" folder. Then after opening works1.xlsx , it is required to insert 1 in sheet1!a4 then save it and colose it. Again after opening works2.xlsx same process but 2 in sheet1!a4. Then again works3.xlsx until works100.xlsx.

Any help would be appreciated
Thanks

[alansidman]

This is untested:

Please Login or Register  to view this content.

[LAVA2]

tHANKS FOR THE ANSWER