*Introduction* My users love Microsoft Excel! Many of them would struggle to get through a work day if they didn't have their beloved Excel. One of the biggest challenges our development group faced when we began working with BSP is that there isn't any build in Microsoft Office Itegration. Our users were spoiled by such conventions of classic Basis technologies like Excel Integration in the ALV Grid and the ability to just about any report to Excel. Over the years we had even developed some applications that took advantage of the office integration classes. Finally we came to an application that was being redeveloped in BSP. Originally this application completely ran in Excel with many macros developed over the years. To avoid recreating all these complex Macros in BSP and ABAP it was decided that a portion of the application would remain in Excel. The challenge was how to integration this with the rest of the bsp application. We had to be able to pass data into the Excel spreadsheet from the main application. From there users would work with the data in Excel and allow the imbedded macros to manipulate the data. Finally the resulting data had to be passed back to the main application. 
6 Comments