Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

With Copilot, Microsoft has built artificial intelligence directly into its Office programmes. However, this is not the only way to utilise the benefits of AI in Word, Excel and PowerPoint.