代表者の戯言

Shorten the start of EXCEl




We want to cut the screen of Start of EXCEL.Then check this program.



example1

GC.Collect()

Dim filename As String = ""

filename = “ENTERfileName”

Dim xlApp As New Excel.Application

xlApp.Visible = False

xlApp.DisplayAlerts = False

Dim xlBook As Excel.Workbook = Nothing

xlBook = xlApp.Workbooks.Open(filename)

System.Windows.Forms.Application.DoEvents()

' close the excel.DEPEND ON you.

'If xlBook IsNot Nothing Then

'xlBook.Close(False)

'End If

' Quit the excek. DEPEND ON YOU.

' xlApp.Quit()

GC.Collect()

GC.WaitForPendingFinalizers()