hello fellas,
Let say I have two workbooks in excel, I want to create a button in the first one, which when pressed closes the second workbook then opens it in another excel's instance. I want this to happen whenever i press the button. the problem is after the first iteration, my code doesnt work anymore because now the workbook is in another instance. Here is my code, Please Help:


Sub NEEW()

'code for saving and closing the workbook
Workbooks(2).Activate
ActiveWorkbook.Save
ActiveWorkbook.Close


Dim appXL As New Excel.Application
appXL.Workbooks.Open "J:\Trading\EURRates\MK AKOLLY\GERMAN.xls"
appXL.Visible = True


End Sub