title: VBA general way for pulling data out of SAP
body: <p>Does anyone know how to use VBA to pull data from SAP Netweaver?</p>
  
  <p>I have a number of daily reports that require exporting data from SAP to Excel and formatting it into a report. I have already written working VBA macros that do the formatting. I have to manually extract the data and run each report macro individually. So much time could be saved if my macro could just go into SAP, grab the data for report #1, format it, grab the data for report #2, etc.</p>
  
  <p>I work with SAP NetWeaver (Release 730, Version 7300.1.3.1079). The reports are just Excel pivot tables and charts.</p>