Two workbooks open & need to close & save one using vba

[ipbr21054]

Hi,
Basic example for you.
I have workbook CARS & also workbook DICO CALC open
From workbook CARS i wish to save & close workbook DISCO CALC

I have the following but get a syntax error compile error
Please advise
Thanks

Private Sub CommandButton1_Click()
    
    Workbooks(“ C:\Users\Ian\Desktop\REMOTES ETC\DISCO II CODE\DISCO CALC.xlsm").Close Savechanges:=True
                                                    
End Sub

 

[Alex Blakenburg]

Try:

Private Sub CommandButton1_Click()
    
    Workbooks("DISCO CALC.xlsm").Close Savechanges:=True
                                                    
End Sub