Thread: How to use Excel VBA to query a SAP database?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
  
Posts: 339
Default How to use Excel VBA to query a SAP database?

"Tim Davies" <Tim wrote in message
...
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.

Doesn't SAP have any kind of tool that transfers data directly from a report
or a database to Excel? How will you know what queries to make?

Here are some other links
http://www.sapgenie.com/products/gesix/
http://searchsap.techtarget.com/whit...011772,00.html
http://www.afalinasoft.com/xl-report-sap/

/Fredrik


Reply With QuoteReply With Quote