Thursday 19 January 2017

Bulk Replacements - VB Macro for MSExcel,MSWord

<Macro name="MacroNAME" Ctrl="yes" Alt="no" Shift="yes" Key="68">
            <Action type="0" message="2178" wParam="0" lParam="0" sParam="" />
            <Action type="0" message="2178" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="AA" />
            <Action type="3" message="1625" wParam="0" lParam="2" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="BB" />
            <Action type="3" message="1702" wParam="0" lParam="768" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />

    <Action type="0" message="2178" wParam="0" lParam="0" sParam="" />
            <Action type="0" message="2178" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="CC" />
            <Action type="3" message="1625" wParam="0" lParam="2" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="DD" />
            <Action type="3" message="1702" wParam="0" lParam="768" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />                          
            </Macro>

Step 1: Using above script,  the text "AA" to "BB" and "CC" to "DD" will be replaced with one click.
[Similarly for common tasks just copy paste the Action Type data in order to perform bulk replacements at one click]

Step 2: just go to the mentioned path  "C:\Users\mmadiraj\AppData\Roaming\Notepad++" and in the shortcuts.xml file include the above script and add a short cut key to perform the action.

Step 3: follow step 1 and 2 :)

No comments:

Post a Comment