I have a program that takes a load of data from sql queries and outputs it to an excel spreadsheet.

My program is used to save data read from the Excel file EmployeeMgmt.xlsx. I want to automatically close the form after successfully saving the data to MySQL, delete all lines except the title in the file EmployeeMgmt.xlsx and save the changes. upload this file. Even though I pointed to the correct path of the Excel file, the program created a new file right in the My Documents folder instead of overwriting changes to the original file located in DocumentsSource

My predecessor created an OR processing program via VB.net using Microsoft Jet 4 to open Excel files. Right now though I am experiencing that the systems cannot be opened by both the Office tools and the OR system he created, the computer throwing an error saying that it is already exclusively opened by another user. Before though it was working fine: users could open the Excel file in MS Office and then open it through the OR system. How do I bypass this? Or rather, how do I prevent this exclusive opening thing? I really don’t know how to ask the question because I dunno what to call this MS Office feature.