DC_Excel2Array with MS Excel 2016

[unixkd]

Hi All

oBook := oExcel:Workbooks:Open(cExcelFile) <======= Gives error "Member not found"

Thanks

Joe

[rdonnay]

I need more info.

DC_Excel2Array() is used in a lot of applications.

Please give me a sample program that fails.

[unixkd]

Here is my code:

aData := DC_Excel2Array("C:\PPSDATA\FAITHPLANT\PPCODESEXCEL\PPCODES.XLSX")

I have office 2016 64-bit installed on computer. Windows 7

Excel2ArrayError.png (48.71 KiB) Viewed 8097 times

[rdonnay]

Here is some more information:

https://forum.solidworks.com/thread/67224