OLE functionality for populating Excel files
I am using OLE to populate an Excel file using ABAP code. I want to know where to find a manual/reference of all functionalities for OLE.
SET PROPERTY OF CELL 'VALUE' = USERS-NAME1 NO FLUSH.
Where can I find a complete list of all properties that I can set to a cell?
I want to do something like this:
SET PROPERTY OF CELL 'VALUEFORMAT' = 'Date'.
SET PROPERTY OF CELL 'TextColor' = 'white'
Can you provide some advice?
Use the VBA help for Excel. You'll find that OLE programming is much easier if you use the DOI classes introduced in R/3 4.6C, rather than coding directly.
This was first published in June 2005