Hi all! Please help!
i use 2 macros: one - to open workbook in new app instance and second - to close this workbook. the problem is that new app instance closing together with workbook. How to avoid that ???????????? Thanks in advance!!
Dim appXL As New Excel.Application
Dim Redemptions As Workbook
Sub redemptions_open()
On Error Resume Next
Set Redemptions = Workbooks("Eurobonds Redemptions.xlsm")
On Error GoTo 0
Application.DisplayAlerts = False
If Redemptions Is Nothing Then
On Error Resume Next
appXL.Workbooks.Open "F:\ANALIS\USER\Golinsky\FILES\EUROBONDS\Eurobonds Redemptions.xlsm"
appXL.Visible = True
On Error GoTo 0
End If
Application.DisplayAlerts = True
End Sub
Sub redemptions_close()
On Error Resume Next
Set Redemptions = appXL.Workbooks("Eurobonds Redemptions.xlsm")
On Error GoTo 0
If Not Redemptions Is Nothing Then Redemptions.Close SaveChanges:=True
End Sub
Bookmarks