using Microsoft.Office.Interop.Excel; i open the excel file using Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(location/filename);
when i use this the file opens and i would like for that not to happen and for the program to read the excel file in the background. I tried
lApp.Visible = false;
xlApp.DisplayAlerts = false;
before the Open statement but it still appears.