title: Excel Macros with Javascript
body: <p>I wish to manipulate excel spreadsheets using macros in Javascript rather than the default VBA.  I can execute javascript code using the following VBA code</p>
  
  <pre><code>'javascript to execute
  Dim b As String
  b = "function meaningOfLife(a,b) {return 42;}"
  
  'VBA tool to run it
  Dim o As New ScriptControl
  o.Language = "JScript"
  o.AddCode b
  MsgBox o.Run("meaningOfLife", 0, 1)
  </code></pre>
  
  <p>this enables me to execute arbitrary javascript, however I do not have access to the excel spreadsheet from within the javascript environment.  Is there any way I can set and get worksheet values in the active worksheet from within javascript?</p>