Solved: How do I 'close' an open workbook?

[Lester]

Hello again

Does anyone know how I should 'close' an open workbook?

I have tried the following code but there is a syntax error in my attempt at the 'close' command'.

I can comment out the offending line and the code runs OK, but it leaves the workbook open.
Many thanks
Lester

[vba]
Sub ImportLookUp()
Dim oWB As Workbook
Dim oThis As Workbook

Set oThis = ActiveWorkbook
Set oWB = Workbooks.Open("G:\temp\ChargeRatesLookUp.xls")
oWB.Sheets("Charge Rates Look-up").Copy after:=oThis.Worksheets(oThis.Worksheets.Count)
'New line added below - but there's a syntax error
Set oWB = Workbooks.Close("G:\temp\ChargeRatesLookUp.xls")
End Sub
[/vba]

[robsimons]

try it like this:
[VBA]
worksbooks("G:\temp\ChargeRatesLookUp.xls").close SaveChanges:=false/true
[/VBA]

[robsimons]

opps, small mistake... workbooks

[rory]

You just need:
oWb.Close

[Lester]

Sorted! Both suggestions work. I'll go with rory's.
Thanks to both of you.
Cheers
Lester.