Suppressing SAP Analysis for Office Add-in Prompt | Excel forum

Resolved · Urgent Priority · Version 2016

Fri 2 Nov 2018, 21:31 Delegate Anthony said...

Anthony has attended:
Excel VBA Intermediate course

Suppressing SAP Analysis for Office Add-in Prompt

Dear Jen,

SAP Analysis for Office add-in has been installed on to my MS Excel 2016. This add-in appears as a tab “Analysis” in MS Excel.

If I make a change to my data from 7.00 to 6.00 and then close this workbook by clicking on the X at the top right, a pop-up prompt from the Analysis add-in will appear. This pop-up prompt is not issued from Excel or my VB codes.

I understand clicking on the X at the top right will invoke the Workbook_BeforeClose event in ThisWorkbook.
If I put this code “Application.EnableEvents = False” in Workbook_BeforeClose, this will suppress this pop-up prompt from the Analysis add-in. But, it will also suppress all further events which is not good for me.

Is there a way for VB to just detect this pop-up prompt and suppress it from appearing while not affecting all other events?

We only have the dll for this Analysis add-in but not the underlying codes.

Thank you in advance for looking into this issue for me.
I can be contacted on my mobile 07484 612 985. I can send you the screenshots if you could let me know how to get them across to you.

Kind regards,
Anthony Tan

Sat 3 Nov 2018, 13:48 Trainer Jens said...

RE: Suppressing SAP Analysis for Office Add-in Prompt

Hi Anthony,

Thank you for the forum question.

I have no knowledge of the SAP Analysis add-in, but it can be controlled from VBA, but you will need to activate the right object library and find the code. In the visual basic editor click Tools -> References and tick the SAP object library. By doing this you can control the Add-in, but you will need to know to control the objects.

I have found a couple of links (see below). This is suggestions to how to enable events after before close.

I hope this can help you in the right direction.

https://www.pcreview.co.uk/threads/setting-application-enableevents-true-after-thisworkbook-close-call.2745438/

https://www.excelforum.com/excel-programming-vba-macros/485173-enableevents-beforeclose.html

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector