asingh
11-10-2010, 07:24 PM
THIS IS NOT A HACK REQUEST
Hi,
I have a bunch of files which I need to open, do some formatting, delete out the VBA content and save. I have put in the following..
1. Open file.
2. Process.
3. Save and Close.
Now IF the files VBA project is locked (password protected) and I do know the password, what code can be used to supply the password and unlock the project delete the contents, and lock the project back. I need to lock the project back, since some tabs are xlveryhidden.
I did search the www, and mostly found sendkeys methods, even that was not working.
I also have working code which deletes out the VBA content but fails if the project is locked/password protected for 'viewing'.
Help would be great....! Thanks...!
Anil
Hi,
I have a bunch of files which I need to open, do some formatting, delete out the VBA content and save. I have put in the following..
1. Open file.
2. Process.
3. Save and Close.
Now IF the files VBA project is locked (password protected) and I do know the password, what code can be used to supply the password and unlock the project delete the contents, and lock the project back. I need to lock the project back, since some tabs are xlveryhidden.
I did search the www, and mostly found sendkeys methods, even that was not working.
I also have working code which deletes out the VBA content but fails if the project is locked/password protected for 'viewing'.
Help would be great....! Thanks...!
Anil