Hi everyone,
I am trying to think of the best way to release "updates" to a vba file.
This is because at work, we create files but there are so many employees that its very difficult to manage all the versions floating around.
Right now, I am using the Microsoft Visual Basic For Applications Extensibility 5.3 reference to edit the modules.
This works unless I have a password in the VBA project.
I know all the passwords. But I cant find how to temporarily remove the password, edit the script, then add the password again.
Could anyone please point me in the right direction?
Also, I would like to stay away from Send Keys as I feel like its very unreliable.
If you have another method, I am also open to that too.
thanks in advanced!
Bookmarks