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
