title: ExecuteExcel4Macro to get range/charts from closed workbooks
body: <p>I use these lines to get values from closed workbooks:</p>
  <pre><code>Arg = &quot;'&quot; &amp; Path &amp; &quot;[&quot; &amp; File &amp; &quot;]&quot; &amp; Sheet &amp; &quot;'!&quot; &amp; &quot;R4C4&quot;  
  Arg = CStr(Arg)
  GetValue = ExecuteExcel4Macro(Arg)
  </code></pre>
  <p>Is there another way than loop to get values from a range? The loop solution is working, but it would be clearer if I could get the range directly with <code>ExecuteExcel4Macro</code>. I've tried to input a range in <code>Arg</code>, but it returns an error.</p>
  <p>I have the same question for charts, how can I get them? My solution for the moment consists of getting values and replotting the charts. It works, but I would be happier with a <code>GetChart(Chartname)</code> function.</p>
  <p>I've seen that I can use ADODB connection to get value from closed workbooks. But it was a little too complex compared to <code>ExecuteExcel4Macro</code>. Would it be easier to use ADODB connection in the case of range/charts?</p>