title: Run Excel macro when excel is not installed
body: <p>I have a excel workbook. I need to show it as a HTML page that will be refreshed automatically(say every 2 minutes). For that i need to run the calculations on every sheet and then save as HTML. I will figure out later how to swap the new HTML file for the old one later. I already have a macro in excel that does all the calculations and then saves as HTML every 2 min. All i need to do is call that macro</p>
  
  <p>The problem is that the machine on which all this is to take place is a server machine and thus MS office cannot be installed on it. Thus i cannot use Excel COM Inter-op. </p>
  
  <p>One was is if i could write a .net program or a Vb Script that will run the macro. But a .net program always uses inter-op.</p>
  
  <p>Another way is if i could save the book as a HTML and run the macro in the HTML itself(Dont know if the HTML has the VB A code). Here also i found that i require Visual Basic Editor which i cant install( as it comes with excel only).</p>
  
  <p>I would prefer not to use third party soft wares.</p>
  
  <p>Can any of the above two procedures be implemented in the given conditions? if not is there any other way?</p>
  
  <p>UPDATE:</p>
  
  <p>Have been looking into open XML for a solution and have finally found that open XML 2.0 cannot run excel calculations as the SDK does not have the calculation engine. Does open XML SDK 2.5 have the calculation engine??</p>