title: Any MDX query within Excel vba?
body: <p>is there any way to execute MDX query within Excel VBA? <p>
  I thought that it can be done through <a href="http://support.microsoft.com/kb/257819" rel="nofollow">ADO</a>, similarly as in SQL case (yes, I'm aware that SQL is different than MDX - issue which was mentioned many times on Stackoverflow).
  <br> Unfortunately I can't find any examples.</p>
  
  <ul>
  <li>Some told about using external tools to accomplish this task, but I
  don't want to pay for them. </li>
  <li>Some give an examples in XMLA, but I want to execute simple MDX query
  instead</li>
  </ul>
  
  <p>.</p>