Microsoft Excel 16.0 object library? RRS feed

  • Question

  • I am trying to open an excel file and read the last cell in the "A" column programmatically using VB.net. I have the code written and have created a simple 1 row spreadsheet in order to start the process. When I run the code I get this error.

    System.Runtime.InteropServices.COMException: 'Sorry, we couldn't find C:\slc.xlxs. Is it possible it was moved, renamed or deleted?'

    I have created a new document in the root directory and as you can see it still says that it can't be found. I can open both files manually without issue.

    I am running the code on a windows 10 professional system, using Microsoft office 365 (Excel).

    and have enabled Microsoft Excel 16.0 object library.

    I've exhausted my resources looking for an answer, please help

    Tuesday, January 19, 2021 12:46 AM