Your questions demonstrate your unfamiliarity with VBA.

To run the macro you need to be able to install the macros in your normal template (or other template of your choice).

To do this you will need to enable Developer mode. This is done through file->options->Customize Ribbon

In the right hand column of the dialog box that pops up make sure that the Developer check box is ticked.

This will enable the Developer Tab on the word Ribbon

Select the Developer Tab and click Visual Basic - this will open the VBA IDE.

Copy and paste the code above to the IDE and then close the IDE or minimise it.

In Word, select the Developer Tab again if necessary and then click on Macros. This will present a list of macros that you can run. If you have copied the code correctly this will include the macro 'convert_excel_list_to_lower_case'.


The filepicker is a dialog box which pops up when you run the macro and allows you to navigate to, and select, your excel workbook. This is the workbook you will have created with a list of the words you wish to change to lower case.