Hello subramaniyanveera,
As far as I know, Microsoft Access Database Engine does not support to run macro. If you want to run a macro in Excel, you have to install Excel, especially you used Excel Interop Api in the macro.
Best Regards,
Terry
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.