Skip to Content
Former Member
Mar 18, 2011 at 07:13 AM

Issue in Background mode -Excel downloading using typepool OLE2


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.


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 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.