View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Davies Tim Davies is offline
external usenet poster
 
Posts: 2
Default How to use Excel VBA to query a SAP database?

Hi Everyone. A weakpoint to many spreadsheets I have written is that a
report must be run within SAP and then exported manually to a spreadsheet,
that is then parsed by a control spreadsheet to obtain the information I
want. A solution to remove this step is to query SAP directly from Excel to
obtain the required data.

Does anyone know if there is an Excel add-in I can use and/or any VBA
examples of how I can create such an interface?

All help will be greatly appreciated.