Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Issue in Background mode -Excel downloading using typepool OLE2

Former Member

‎03-18-2011 7:13 AM

0 Kudos

Hi ,

I am working a report using OLE type pool.

Based on conditions the colors should display in excel sheet. As its displaying the colors correctly.

Issue:

1) How we will execute the OLE download in back ground

as i am using the below code as visible '0', if Visible '1'. the file is executing in fore ground and viewing the records.

SET PROPERTY OF H_EXCEL 'Visible' = 0 "in background

Issue: But again there is a wait until the excel is downloaded completely. How can we avoid it is ,If we run in backgroundu2026.it doesn't create the file. What could be done such that user opts for excel output and should not wait on screen.

Please let me know any option OLE to get the file in background with out waiting in selection screen.

1 REPLY 1

Clemenss
Active Contributor

‎03-19-2011 9:28 PM

0 Kudos

Hi samruth,

The function of ABAP/4 OLE Automation Controller is to connect to Desktop applications supporting OLE2 that can be thus be called from R/3.

In background, there is no Desktop.

Thats it.

There is this really interesting [abap2xlsx|http://wiki.sdn.sap.com/wiki/display/ABAP/abap2xlsx] project. If you are prepared to forget OLE then this is the way to go.

Regards,

Clemens