How write over cell with VBA

[Joxu]

Hi
I have 2000 files where I need to write over one cell in each files. All these file are in same folder. All files are protected with password, and VBA are also Protected with password.
In every file have worksheet what are named "environ". On that sheet I need to change one cell value.
So my question is. How can do this, open file, open vba, unprotect file, write to each file to the environ worksheet D5 value 1. Then save files again with original names.

Is it possible?
-Joxu

 

[Joe4]

How can do this, open file, open vba, unprotect file, write to each file to the environ worksheet D5 value 1. Then save files again with original names.

You should be able to get all of the code you need to do this (except looping through all files in the folder) with the Macro Recorder. Simply turn on your Macro Recorder, and record yourself doing all those steps manually.
The Macro Recorder is a great tool for getting this kind of code snippets.

To loop through all the files in the folder, you can use the code found here:
http://codevba.com/office/loop_files_in_folder.htm#.XPUQe_lKipo
So the code you recorded would just go inside that loop.

If you have any issues putting all together, post the code that you recorded here, and let us know the full file path of the folder where these files reside.