title: Pulling data from SAP using Excel Macros
body: <p>So I am trying to pull data from SAP using excel macros. I am new to VBA so please bear with me. I found a topic on here called VBA pulling data from SAP for dummies and I am confused. 
  What I am trying to do is as follows:</p>
  
  <ol>
  <li>Copy a notification number from a list in excel.</li>
  <li>Go to the appropriate screen in SAP and paste this number in the search box.</li>
  <li>Open the long text box.</li>
  <li>Copy the long text.</li>
  <li>Paste into excel. </li>
  </ol>
  
  <p>Here is the link <a href="https://stackoverflow.com/questions/19452461/vba-pulling-data-from-sap-for-dummies">VBA pulling data from SAP for dummies</a></p>
  
  <p>I can't seem to get by Set session = connection.Children(0) 'Get the first session (window) on that connection.</p>
  
  <p>Any help is much appreciated. The reason I am doing this is because SAP wont export longtext and it takes an act of God to get it fixed. </p>