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?