Wednesday, September 28, 2022

Solving ActiveX- Excel error -2147319784 & Crash Issue

 I was upgrading LabVIEW 7.1 code to LabVIEW 2020 (32 bit) which has activeX excel report generation.  Code upgraded for Win 10 OS 64 bit & Office 365 - 64 bitVersion. While executing the EXE in some other Win 10 OS with Office 365 version machine got Excel Error "-2147319784". 

To solve this issue ActiveX function used VI properties->Execution->Preferred Execution System changed to User Interface based on the https://forums.ni.com/t5/LabVIEW/What-is-error-2147417851/td-p/103921 forum suggestion. 

EXE crashes while generating Excel report in Win10-64 bit OS with Office 2016-64 bit machine. 

To solve this issue, we removed the “Save As” ActiveX function in code & replaced with Save function. After that it works in both Office 365 & 2016 (both 64 bit) with LabVIEW 2020 32 bit

Here development machine Office 365 version also important we used Version 1609

Hope this will help...