You can automate specific tasks by repurposing Word's built-in commands. It requires a bit of VBA, but it's super easy. Here's how.

You can use the same method to create many print functions in Excel using VBA. Steps for creating the print function button are the same; just the command syntax differs.

Using some relatively simple VB coding syntax, you can design a command button or other control option to create a new workbook and export data to it for use in Excel.