SAP <----> Excel (RFC)

[balajishahrsap]

Hi Team,

We have the requirement to convert an Excel form (with Macro's) to SAP.

The challenge here is we have about 400 unique Conditions when we compare all the macro's. So what we are trying to propose is to have this Exel in Server and from SAP we will pass the inputs to Excel sheet in server and get back the results from it.

Please advise if this is a feasible. And also the methods to call the Excel marcro's in SAP .

[balajishahrsap]

Hi Mike,

Thanks for your reply,

The reason why we are thinking in this direction is to avoid such combination of nested IF conditions in SAP.

if you could advise us on how to connect to Excel from SAP and get the derived results will be helpful in achieving this solution or else if there is any other opinion also please share with us.

[pokrakam]

You can do a lot of Excel interaction using OLE, please review the doco on this: link and there is also plenty of info on here.

I would still run very very far away from this solution. ABAP is more than capable of handling 400 IF statements, and it can almost definitely be simplified compared to what you're restricted to with Excel macros. Having business logic split in different platforms is also bad. The effort is probably the same. So all round I'd go for a Web Dynpro app or something like that.