I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office which means we are moving to Office 2016. I'm finding that my application doesn't behave well with Excel 2016. It stops part of the way through and simply won't finish.
The original application was built in Visual Studio 2010. It is using .NET Framework 4.5 and references Microsoft Excel 14.0 Object Library. I have rebuilt the app in Visual Studio 2015 but with the same parameters as listed above.
My question is: Are you aware of any compatibility issues with VB.net and the various versions of Excel and, if so, what should I being doing to address this?
I hope I'm explain and asking questions correctly. Therefore, please don't hesitate to ask any question that I (hopefully) can clear up.
In advance, thanks for your input.