Why can't we use copilot with VBA?

Question

Hi, I am learning VBA and am doing a course with Microsoft. They gave me a task to use Copilot to write VBA script.

That being said With VBA in use I can not use copilot. (VBA does not allow me to autosave and by extension Copilot can not be used).

Is there a way to use it or do I have to use a completely new workbook just for copilot?

If so that would be pretty counterproductive to AI's efficiency so am not sure why they would have done that.

Answer 1

Copilot is not supported in environments that use VBA due to the limitations of the VBA environment itself. Specifically, Copilot requires autosave functionality to operate effectively, which VBA does not support. Therefore, you cannot use Copilot while working directly within a VBA context.

If you want to use Copilot, you would need to work in a different environment, such as a new workbook that does not involve VBA. This limitation can indeed feel counterproductive, especially when considering the efficiency that AI tools like Copilot are designed to provide.

---

References:

• Use Copilot in Power BI Desktop
• Copilot is missing, disabled, or doesn't work correctly