Click the button in the spreadsheet to run the command. READ: Change Cell Background Color in Excel with VBA Editor What is the difference between VBA and script in Excel?

Millions of small business owners and entrepreneurs all over the world use Microsoft Excel to help with common accounting, forecasting and inventory tasks. With Excel's integrated tools, it is ...

Click the "Command Button" in the Excel spreadsheet. Microsoft Word opens automatically and displays the file from the path you entered in the Visual Basic editor code window.

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.