Below are some example macros I have written in the past either for myself or for customers. They are intended to provide some real-world examples of how you can implement macros and what you can do with them. Click on the link below that interests you; it will either lead you directly to the Excel/Word document with the macro (to view the code, press Alt+F11) or to a blog post that goes through the macro where you can again download the macro document.
Example 1: Save a Word document with a pre-determined prefix and suffix