Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question