title: how to import data from sharepoint to excel using macro
body: <p>I wanted to know if there's a way to import data from SharePoint to Excel using Macros. What i want to do is have a library in my sharepoint in which i have an excel document. When i download the document and open it, i would like to automatically import the data from sharepoint and have some graphs. </p>
  
  <p>What i've tried to do is export the data of a list using the SharePoint ribbon. Then i opened the file.dll.iqy in notepad, hoping to find the macros to import datas. What i've found was this : </p>
  
  <pre><code>WEB
  1
  http://win-sharepoint:9090/sites/PPMO/_vti_bin/owssvr.dll?XMLDATA=1&amp;List={C51D70F2-4D7B-4F20-AE05-379DA264F685}&amp;View={8399F350-92C7-4942-  B8B0-464A735AFC72}&amp;RowLimit=0&amp;RootFolder=%2fsites%2fPPMO%2fLists%2fStade%20du%20projet
  
  Selection={C51D70F2-4D7B-4F20-AE05-379DA264F685}-{8399F350-92C7-4942-B8B0-464A735AFC72}
  EditWebPage=
  Formatting=None
  PreFormattedTextToColumns=True
  ConsecutiveDelimitersAsOne=True
  SingleBlockTextImport=False
  DisableDateRecognition=False
  DisableRedirections=False
  SharePointApplication=http://win-sharepoint:9090/sites/PPMO/_vti_bin
  SharePointListView={8399F350-92C7-4942-B8B0-464A735AFC72}
  SharePointListName={C51D70F2-4D7B-4F20-AE05-379DA264F685}
  RootFolder=/sites/PPMO/Lists/Stade du projet
  </code></pre>
  
  <p>I tried to save it as a macro, but the result i got was not the one expected.
  Do you have any idea how to do this ? </p>
  
  <p>Thanks a lot </p>