AnsweredAssumed Answered

Annoying Excel message since SWInspection

Question asked by Graeme Paylor on Feb 12, 2015
Latest reply on Feb 24, 2015 by Graeme Paylor

Hello all, first timer here.

 

We have been using InspectionXpert for a couple of years and created an Excel template (.xltm) which has VBA coding to ‘initialise’ the document after importing the data.

With the advent of Solidworks Inspection, when the import to Excel is complete, the attached message comes up which I fully understand but I’d rather it didn’t appear.

I have searched the www to try and find a resolution (revolves around the usage of “Application.DisplayAlerts = False”) but there seems to be nowhere I can put the code to prevent the message popping up.

Clicking Yes allows continuation of process and the macros within are fully functional.

I realise that this is quite a specific query and does not ultimately affect usability – it’s just another irritation caused by an upgrade.

Thanks if there is anybody that can advise.

 

Graeme Paylor

 

VBA MSG.JPG

Outcomes