I'm developing a VB forms application that accesses excel sheet content using the office interop library. Developing on Windows 8 with Office 2016.
Take the following trivial example:
Import excel = Microsoft.Office.Interop.Excel
Private Sub Form_Load(sender As Object, e as EventArgs) Handles MyBase.Load
Dim excelApp as excel.Application = New excel.Application
You can use the
Marshal class for that (MSDN). I found that running all excel objects in reverse order was the best -> worksheet, workbook, application.