We’ll be using Word in the examples, but you can also apply the same code to an Excel file. SEE: 83 Excel tips every user should master (TechRepublic) The demonstration file uses Word fields.

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?

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.

However, by using Visual Basic for Applications, or VBA, you can also create macros or command buttons to perform various printing tasks within Excel much faster and more efficiently.