Automate Copilot in Excel

Hi,
Is it possible to automate opening Copilot in Excel and send a prompt using VBA?

Currently, Copilot in excel seems to work only through the UI, where we have to manually click the Copilot button in the ribbon section and paste the prompt. I want to automate this process so that, with a single click, Excel opens Copilot and enters the prompt automatically.

If this is not possible, are there any alternative approaches to achieve similar automation?