Open Excel file for reading with VBA without display
Not sure if you can open them invisibly in the current excel instance
You can open a new instance of excel though, hide it and then open the workbooks
Dim app as New Excel.Applicationapp.Visible = False 'Visible is False by default, so this isn't necessaryDim book As Excel.WorkbookSet book = app.Workbooks.Add(fileName)'' Do what you have to do'book.Close SaveChanges:=Falseapp.QuitSet app = Nothing
As others have posted, make sure you clean up after you are finished with any opened workbooks