Does Excel Application Scope run Background Queries when file is opened?

Dear All,

I have a file with Background Queries running automatically when it is opened. In my current project I need to open the file, let the query run and after it finished start processing the data.

I would like to ask if these Queries do run when I open the file with Excel Application Scope? I did not see any sign on the statusbar in Excel, but would be nice to have some kind of confirmation.

Thank you in advance!

1 Like

Hi @Balint1367

As per my experience if we dont enable the flag of visible within Excel Application Scope activity it works in background even if it is open but at the same time we can only see that what data is processing in it.

And at the same time if we start doing modification the bot gets stop n throws error bcz we disturb the bot while he is working.

I have tried this scenario at that time i got the error n bot stops working.

Hope this may help to solve your query
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Looks like it doesn’t work on the background. Rather use the excel workbook activities if you want the process to run from the background.

Hello @Balint1367 try this:

  1. Use a Log Message activity to log a message indicating that the Excel file is being opened.
  2. Use Excel Application Scope to open the file.
  3. Add a Wait activity with an appropriate timeout (e.g., 10 seconds) to allow time for background queries to run.
  4. Use activities to check for the presence of specific sheets, data, or other indicators that the queries have completed successfully.
  5. Use a Log Message activity to confirm that the data is ready for processing.
  6. Proceed with the data processing activities.

Cheers! :slight_smile: