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