Question VB.NET to run macro amending VBA in Excel

[malcmail]

I have a pile of spreadsheets that every so often need to be updated. The files themselves are not locked but the VBA is. When they need updated it's a case of updating one and then open the next file, enter the password for the VBA, copy the new code in on top of the old, then save and close. Is this something that I can automate using VB.NET? My knowledge on it is quite poor to be honest but if it is something that will help out here I'll start learning in a hurry. I'm hoping to hear that I can loop through a number of files in a directory, open, do what needs to be done and save, with no interruption from me once the application is running. Thanks in advance.

 

[JohnH]

Research VBComponents collection. From what I read you can't unprotect VBProject by code, you have to do that manually.