VBA (Macro) code in the workbook
I have created a new workbook which has got 15 tabs (25 worksheets) in it. Each tab is a query and you know a workbook can contain many BW queries inserted into it. Since it is a big workbook, it takes some time to execute individual queries contained in each tab. As and when a query in the workbook executes, the BEx forces to get workbook screen infront of whatever screen you have. For example, if I have executed this report in the morning and if it takes 4 hours to execute this report, then I will start working on other tasks. While I am working on other tasks, my work will be hampered whenever the BEx screen appears in between.
I have to write a VBA (Macro) code in this workbook and control the forcing of BEx screen to appear till all the tabs (queries) in this workbook are executed