Skip to Content
0
Former Member
Mar 12, 2007 at 02:36 PM

OLE Automation to Excel Applications

49 Views

Hii Friends,

I am working on an OLE automation object, where my report program should call an Excel file using OLE connection.

Here I am able to print all the data in Excel, from SAP. However I am facing a problem in writting -ve values.

i.e

if value of a variable, say temp = -5 in ABAP, is should display (5) in Excel.

This is the requirement.

what I am doing is

concatenate '(' temp ')' into str_temp .

And passing it to Excel, bt in Excel it still shows -5.

Can somebody pls help me, how to fix this ?

Is thr any property to fix this?

Regards,

Hardik