PhilHibbs

I have a load of Excel spreadsheets with VBA code attached, and I want to update them all to the latest version of the VBA code. AutoIt seems like the tool for the job. Has anyone done anything like this before?

I'm thinking like this...

1. Place the new version of the VBA code in the clipboard
2. Open the .xls to be updated
3. Run the AutoIt script which...
3a. Sends Alt-F11 to open the VBA macro editor
3b. Switches between the code windows, attempting to work out which window contains the module that is being updated
3c. Select all and paste clipboard contents
3d. Close the VBA macro editor
4. Save and close

3b is probably the hardest step. I could include snippets of the old version(s) in the new code and search for these. Ideally I would have some kind of structured header, but I don't have that right now and I want to update the code in several dozen spreadsheets.

Don't cha love it.
Local $test1 = Random(0, 1, 1) MsgBox(0, "Results 1", "Original  : " & $test1 & @CRLF & @CRLF & "Invert 0|1: " & _Invert0_1($test1)) Local $test2 = "101" MsgBox(0, "Results 2", "Original  : " & $test2 & @CRLF & @CRLF & "Invert 0|1: " & _Invert0_1($test2)) Local $test3 = "I have 101 things to do (10)." MsgBox(0, "Results 3", "Original  : " & $test3 & @CRLF & @CRLF & "Invert 0|1: " & _Invert0_1($test3)) Func _Invert0_1($In)     Return Execute(StringRegExpReplace($In, "([^10]*)([10])([^10]*)", "'${1}' & Number( ${2} = 0 ) & '${3}' & ") & '""') EndFunc   ;==>_Invert0_1

Thanks you for your message, I'm glad FastFind prove to be useful :-) 

It's been a while since I've been back to check this thread, but I'm still using this library in almost every au3 project I do. Despite occasional bugs, it saves me so much work, and makes my scripts MUCH faster.
I've downloaded a copy of your source from github and will try making sense of it if I find the time and motivation. Thanks for your contribution, it's much appreciated!

This function is included in