title: Can a Macro (Excel) be processed by ssis?
body: <p>I want to Import an Excel sheet to SQL-Server and I am struggling with the Import. So I have to Change some cells in the Excel sheet before it is possible to Import the sheet. 
  the Import should be processed fully automated so I Need a solution which is automatically processed by Excel before SSIS is loading the file. </p>
  
  <p>So is it possible to write a Makro which will be automatically conducted when the loading process is starting?
  Or is it possible to excecute an Excel Makro from a SSIS package?</p>
  
  <p>I'm using SQL Server 2014 and Excel 2013 </p>