0

Using Autopilot to run reports unattended

Jet Reports Historic Posts

August 29, 2011 17:18

None

Follow

Do you have any other add-ins enabled in Excel?

Bingo! Disabling the only other add-in made the pesky error message disappear.

Thanks (again)!

Hans

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts August 29, 2011 17:18

  I would like to use Autopilot to run a number of reports (from a shell script) in one go, unattended.
  
  Each time a report starts, the main Excel window comes up, and then a message box(translated from Dutch) "This application is about to initialise possibly unsafe ActiveX controls", requiring me to click OK to proceed (or Escape to abort).
  
  The message doesn't mention which ActiveX controls are to blame, but is there a way to get rid of it so that I can run my reports unattended?
  
  (Windows Server 2003, Jet Reports 2010)
  
  regards
  
  Hans

• 0
  
  Jet Reports Historic Posts August 29, 2011 19:44

  Hi Hans,
  
  This article about ActiveX settings in Office 2010 might help:
  
  http://office.microsoft.com/en-us/excel-help/enable-or-disable-activex-settings-in-office-files-HA010354314.aspx
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 30, 2011 07:37

  Thanks for your reply! I should have mentioned that I use Office 2007, not 2010. I have tweaked all available settings in Office 2007's "Trust Centre", but to no avail.
  
  What I find puzzling is that
  
  

  • I never get the warning when running a report manually, only when using Autopilot
  • pressing "Escape" instead of "OK" doesn't prevent the report from being run correctly
  • The error message window's title bar says "Microsoft Forms" - assuming there is no malicious code involved, is the problematic ActiveX actually made (and signed) by Microsoft?

  As I don't know enough about Windows and its security machinery I hope my system administrator can solve it.
  
  
  Hans
• 0
  
  Jet Reports Historic Posts August 30, 2011 15:39

  Hi Hans,
  
  Wow, that is weird! I haven't seen something like this before that I can remember. It's really strange that it only happens with AutoPilot. Does it always happen even if you create a new workbook from scratch and run it (say a workbook with no Jet functions)? I also don't know what the "Microsoft Forms" bit is about. Do you have any other add-ins enabled in Excel? What happens if you disable all but the Jet add-in?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 30, 2011 20:43

  Hans,
  
  Nice! Glad you figured it out. Btw, just so I know for the future, what add-in was it?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 30, 2011 21:28

  It was the (an?) Excel add-in for Exact Globe 2003 (filename EG2000.xla)