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.

After that, you just have to run the Macro, and Word and Excel will display the complete file path of the opened document and spreadsheet in the Title Bar.

Microsoft Word can accommodate a surprising number of file formats, and even take in Excel and PowerPoint data, though it might look funny. Here's how.

Learn how to use a Microsoft 365 setting to choose whether to open files in the online or desktop app, giving you full control for each file.