Close workbook in different instance

[Legacy 287389]

Hi good people!,

I use this code to open a workbook in another instance:

Dim appXL As New Excel.Application
    
    appXL.Workbooks.Open "G:\All Users\Jurie\Test\Hotel Maintenance V1SE.xlsm", IgnoreReadOnlyRecommended:=True

Now, when I close the child workbook, I would like the parent workbook to close as well. I have tried this, but it does not work:

Workbooks.Close "G:\All Users\Jurie\Test\Hotel Maintenance V1SE.xlsm"

Wrong number of arguments or invalid property assignment

Please someone help me out here?...thanx a lot!

 

[tusharm]

Not sure I understand the parent-child part in the context of 2 separate Excel instances but maybe you meant:

Workbooks("Hotel Maintenance V1SE.xlsm").Close

Hi good people!,

I use this code to open a workbook in another instance:

Dim appXL As New Excel.Application
    
    appXL.Workbooks.Open "G:\All Users\Jurie\Test\Hotel Maintenance V1SE.xlsm", IgnoreReadOnlyRecommended:=True

Now, when I close the child workbook, I would like the parent workbook to close as well. I have tried this, but it does not work:

Workbooks.Close "G:\All Users\Jurie\Test\Hotel Maintenance V1SE.xlsm"

Please someone help me out here?...thanx a lot!

 

[Legacy 287389]

tusharm,

the method you gave will not close the workbook because it is in another instance. I do need to add the workbook path..which I did. The OPen wb works well, but not the close wb?

 

[tusharm]

I relied on your attempt at closing the workbook, which did not include a reference to the other instance.

So, try,

appXL.Workbooks("Hotel Maintenance V1SE.xlsm").Close

tusharm,

the method you gave will not close the workbook because it is in another instance. I do need to add the workbook path..which I did. The OPen wb works well, but not the close wb?

 

[Legacy 287389]

Good day Tusharm,

I was away for the holidays...thanx for the feedback..I THINK I tried what you suggested and had some problem, just cannot remember exactly now. I will however check it out again...thanx a lot..

 

[RoryA]

I would suggest you use a workbook variable to make life easier

Dim wb as workbook
set wb = appXL.Workbooks.Open("G:\All Users\Jurie\Test\Hotel Maintenance V1SE.xlsm", IgnoreReadOnlyRecommended:=True)
' other code
...

wb.Close

 

[Legacy 287389]

RoryA,

thank you...I will certainly look at all my options, will give you feedback a bit later on...thanx again..

 

[Leonideez]

I believe the issue is how the variable is defined. instead of using the defined ":appXL", use the source in the code "Excel.Application"

Excel.Application.Workbooks("Hotel Maintenance V1SE.xlsm").Close

 

[Leonideez]

I believe the issue is how the variable is defined. instead of using the defined ":appXL", use the source in the code "Excel.Application"

Excel.Application.Workbooks("Hotel Maintenance V1SE.xlsm").Close

seems this only works if the other instance is already open before starting the macro...