asked on
Set xlsApp = New Excel.Application
With xlsApp
.Visible = False
Set xlsWbk = .Workbooks.Open(strPathOfSourceFile, , True)
End With
Set xlsWst = xlsWbk.Worksheets(strWorksheetName)
Set rngLimitsTestCell = xlsWst.Cells(1, 1)
Set rngLimitsTestCell = Nothing
Set xlsWst = Nothing
xlsApp.DisplayAlerts = False
xlsApp.Quit
xlsApp.DisplayAlerts = True
Set xlsApp = Nothing
xlsApp.DisplayAlerts = False
xlsApp.Quit
xlsApp.DisplayAlerts = True
Set xlsApp = Nothing
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
As far as i read the code xlsWst is the worksheet which in turn must close first before the application.
about this... Set rngLimitsTestCell = Nothing i believe that can be ommited.
Hope that helps