Real Time SAP Excel Reporting using simple VBA Programming

Microsoft Excel is extensively used in all business. There are many SAP Consultant or Business users not aware we can interface Microsoft Excel with simple VAB Code. Then we have an interesting question. If we use and SAP do we stop using Excel? The answer is NO.

As an SAP Consultant / Business owners you may have some report customized for your business requirement. There will be few reports which are used by one or two users. Now the next question, how much money we spend to develop this report. Quite often this report again downloaded and viewed in Microsoft Excel.

Can we get the report directly in Excel from SAP? Yes, it is possible and very simple. You can get the data from SAP directly in Excel. You can format the report as you like. You can create online dash board etc.