VBA Functionality in desktop applications?

I would like to give excel-like functionality in my own applications, giving user ability to program the application using VBA. What's the right approach? Does MFC/COM/ATL/Automation lead? I'm presently using MFC, but have not worked with COM.