0

VBA code for "Run in Background"

Sydney Stroyer

June 06, 2018 06:28

None

Follow

Is it possible to get the run command for running reports in the background?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis June 08, 2018 17:07

  I doubt if this would be feasible.

  You've probably noticed that, after you choose ‘Run in Background’ (which, yes, you should be able to do via VBA) you are prompted to save the file and close it.  VBA would not be able to interact these messages.

  You may be able to use VBA to get to that point in the process, but it would still require user interaction, from there.

  Edited by Harry Lewis June 08, 2018 17:07
• 0
  
  Sydney Stroyer June 08, 2018 17:48

  I understand the user still has to interact it just make it easier then them going to the ribbon.
  It makes a nice user interface. I use it right now for run I just don't know the code for the run in background.

• 0
  
  Harry Lewis June 08, 2018 21:49

  Hello Sydney -

  As far as I can tell, there is no way to use VBA to launch the utility that controls the run-in-background feature.

  Edited by Harry Lewis June 08, 2018 21:49