Close Specific Work book

[cuetipper]

I am trying to save and close a specific open workbook without prompts.
Why does this not worK?

[LEFT][COLOR=#222222][FONT=Verdana]    For Each Workbook In Workbooks[/FONT][/COLOR]
[COLOR=#222222][FONT=Verdana]    If Workbook.FullName = "ExcludedWo.xlms" Then Workbook.Close (True)[/FONT][/COLOR]
[COLOR=#222222][FONT=Verdana]    Next Workbook[/FONT][/COLOR][/LEFT]

 

[Kamolga]

I am trying to save and close a specific open workbook without prompts.
Why does this not worK?

Normaly I would use .name=​

"ExcludedWo" without extension
​

I can't test it but I would try

application.displayalerts=false
workbooks("[COLOR=#222222][FONT=Verdana]ExcludedWo").close[/FONT][/COLOR]

 

[cuetipper]

Thank you.