Dialogue script not loading
Applies to
Dialogue Elite software
Summary
Unable to load a calibration script or system suitability script. Exporting chromatogram data to Excel not working.
Cause
Possible causes:
- Excel not correctly installed
- Wrong version of Excel installed
- Conflicting programs on PC
- Registry error due to MS Office install history
Diagnosis and Remedy
Switch on the log functionality in Dialogue Elite: Go to the ‘log’ tab and check the log functionality at the left bottom of the screen. Repeat the situation and when the error occurs go to the log tab, click ‘err’ at the left bottom. See if any errors are visible that relate to Excel.
A known issue occurs when the installation of Office has been removed and reinstalled with another version (i.e. a 32 bit version was replaced by a 64 bits version, or Office 365 replaced by Office 2023). The root cause is that some registry settings are not cleared when the PC was not restarted in between versions. Result is an ‘error loading type library/DLL’. In that case, the problem can be fixed by running a ‘repair’ on the Office installation, and restarting the PC. See this Microsoft KB thread.
Error message in log file:
System.InvalidCastException: Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.set_DisplayAlerts(Boolean RHS)
at Dialogue_Elite.common.ExportDataExcel(String fn, String Tag)