Error while loading a excel file having macros


I have a collection of excel files which has macros.I need to loop through them and access data. The first excel file pass through the code but from the second file its giving the following error.

---> System.Exception : VBA or macro in designer spreadsheet is not supported in Professional Edition. Unfortunately, this feature is only available in Enterprise Edition, but your license is for Professional Edition. Please follow ------ to upgrade your license.

My question is just to load an excel file which has macros do we need to go for enterprise edition?


Please check for differences between Professional and Enterprise.

You can use either of following two approach to solve this issue:

1. Remove macros in your files.

2.Upgrade to Enterprise. You just need to pay the difference between Professional and Enterprise.