I'm attempting to update several VIs that communicated with Excel (v. 2019) from using ActiveX to .NET ("Microsoft.Office.Interop.Excel(15.0.0.0)") in LabVIEW 2016 (Windows 10, & .NET 4.0). My development computer has the Excel version from Microsoft Office 365 ProPlus. I have been able to perform all the necessary methods, except Workbooks.Open or Workbooks._Open. I have confirmed the rest of the VI works by utilizing the Workbooks.Add method. Also, I have attempted wiring many combinations of some (and all) of the "optional" parameters for both the .Open and ._Open methods, but I always get the generic .NET Error 1172. What am I missing?

LabVIEW

wiebe@CARYA wrote:

After 4 hours of debating with copilot, I found a (quite simple) solution for the failing Workbooks.Open.

apparently, the ki doesn't know about

Message 11 of 11

(20 Views)