Open & close external workbook

[JRS]

To open an external workbook I can use:

Workbooks.Open Filename:= _
"File_Path_and_Name.xls"

That code works, tried and tested!
I am cant get it to close again later on in the code.
I have been trying:

Workbooks.Close Filename:= _
"File_Path_and_Name.xls"

But it doesnt work, I just get a compile error.
Any Ideas how I can get that workbook to close? (without saving)
Thanks

 

[VoG]

Try like this

Dim wb As Workbook
Set wb = Workbooks.Open("File_Path_and_Name.xls")
'
'more code
'
wb.Close savechanges:=True