VB to edit VB in Multiple Excel Files

[santa12345]

Hello. I am trying to do the following.
I am in folder ABC.
I have 50 files, a.xls b.xls c.xls, etc...
I want to write a script to open up file A, go into the VB, unfortunately the VB has a passcode, enter the passcode, go into module 1 and replace the one line of code with another "static" line of code.
Save and close the file and move onto the next file within the folder.
The line of code currently within each file in module 1 is the same. The replacement line of code will be the same as well.
Is this even possible?
ANY insight would be much appreciated.
Thank you very much.

 

[santa12345]

I guess to rephrase the above.
I am trying to use vb to copy and replace a module from one excel workbook to approx 500 other workbooks.
I'm struggling with .......the fact that the files I have to copy the module to are different workbook names in different folders.

​