With this code :
Sub TEST()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = New Excel.Application
xlApp.Visible = False
Set xlBook = xlApp.Workbooks.Open( "C:\temp\pippo.xls" )
Stop
xlBook.Close SAVECHANGES:=False
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
End Sub
open and hide the file excel shared "pippo.xls", with office 2010 the file remains invisible, with office 2016 the file remains visible.
the problem occurs only when opening shared files.
How can I solve?
Sub TEST()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = New Excel.Application
xlApp.Visible = False
Set xlBook = xlApp.Workbooks.Open( "C:\temp\pippo.xls" )
Stop
xlBook.Close SAVECHANGES:=False
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
End Sub
open and hide the file excel shared "pippo.xls", with office 2010 the file remains invisible, with office 2016 the file remains visible.
the problem occurs only when opening shared files.
How can I solve?