Bulk modify macros, how to use the code to modify or increase all VBA in EXCEL VBA code one line of code in the
Everybody is good, I want to put my computer all folders or specify folders below VBA in EXCEL VBA code in a change in the file and add a numerical, namely VBAPROJECT THISWORKBOOK inside the VBA code inside unified increase a value,
Such as the original "00:10:20:30:40: D9", by VBA code change all the VBA code to "B8:57:9 A: E1: DG: 88", "00:10:20:30:40: D9"
Or contain "00:11:22:33: BD: F7", by VBA code change all the VBA code to "B8:57:9 A: E1: DG: 88", "00:11:22:33: BD: F7"
Is that unified all contain the VBA code by VBA code will increase all the VBA code "B8:57:9 A: E1: DG: 88", the value to the inside of the arr=Array,
Of course, some with EXCEL VBA code document has done "protection of thin" (" review "menu" protect and share work thin "below), plus VBAPROJECT also added a password, so please everybody take a look at how to batch change,
Is the VBA code:
Arr=Array (" 00:10:20:30:40: D9 ", "5 p: C: they simply C6: BB: C7", "00:14:2 A: D8: DD: D9", "00:11:22:33: BD: F7", "00:1 A: 73: E7:97:0 A", "00:53:45:00:00:00")
To:
Arr=Array (" B8:57:9 A: E1: DG: 88 ", "00:10:20:30:40: D9", "5 p: C: they simply C6: BB: C7", "00:14:2 A: D8: DD: D9", "00:11:22:33: BD: F7", "00:1 A: 73: E7:97:0 A", "00:53:45:00:00:00")
Thank you all!

Note: here is not all mentioned above, namely each code of ARR in EXCEL, but there must be "00:10:20:30:40: D9" or "00:11:22:33: BD: F7" one or two have,
So only request should contain "00:10:20:30:40: D9" or "00:11:22:33: BD: F7" were replaced with "B8:57:9 A: E1: DG: 88", "00:10:20:30:40: D9" or "B8:57:9 A: E1: DG: 88", "00:11:22:33: BD: F7",
About engineering can't see, if I can call an external application VBA to delete original work thin, VBA password? thank you

CodePudding user response:

http://www.autohotkey.com

CodePudding user response:

Miss zhao in the throwing bricks? Students don't understand

CodePudding user response:

Why now here asking questions is the collapse of the demand, can clearly tell you, but,,,
But this code,,, enough to write,

CodePudding user response:

Because there are too many files and computer, want to a solution! Password Cohen, the different of each computer, here's a line of numerical also may be different, but the two values mentioned in the article is there must be one of them

CodePudding user response:

refer to the second floor dollchen response:

miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

CodePudding user response:

reference 5 floor zhao4zhong1 reply:

Quote: refer to the second floor dollchen response:

Miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

If not cancel the password

CodePudding user response:

reference 5 floor zhao4zhong1 reply:

Quote: refer to the second floor dollchen response:

Miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

Between theory and reality "", and many times there is always some gap;
But often "and not"...

CodePudding user response:

refer to 6th floor dollchen response:

Quote: refer to the fifth floor zhao4zhong1 reply:

Quote: refer to the second floor dollchen response:

Miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

If not remove password

Manual can remove password, don't expect can automatically,

CodePudding user response:

refer to the eighth floor zhao4zhong1 response:

Quote: refer to the sixth floor dollchen response:

Quote: refer to the fifth floor zhao4zhong1 reply:

Quote: refer to the second floor dollchen response:

Miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

If not remove password

Manual can remove password, don't expect can automatically,

Put the virtual machine, or in the remote terminal maybe is ok,

CodePudding user response:

refer to 7th floor Chen8013 response:

Quote: refer to fifth floor zhao4zhong1 response:

Quote: refer to the second floor dollchen response:

Miss zhao in the throwing bricks? Students don't understand

Using autohotkey theory can record any manual operation for ahk script, and then modify the ahk scripts automated batch operation,

Between theory and reality "", and many times there is always some gap;
But often "and not"...

Reboot the computer BIOS setup password is can't use ahk script automatically fill in
And restart the computer when setting need to enter login password is can't use ahk script automatically fill in
.