We have used excel object in my project (windows application) . Currently office 2007 is being used . As per the client requirement recently we have upgrated to office 2010.
In order to export the Chart from the application we have created excel template. Upto 2007 it was working well even Macro is disabled.
But after migrating to office 2010 , at run time when we export the chart into excel it throws exception like " Macro is disabled like that ".This problem is solved if i open the excel and enable the Macro manually. But we cannot ask all the users to do the same Manually. So I would like to know Is there any way to enable the Macro programatically using vb.net. Much appreciated If I get the solution ASAP.