Hi will

Use set in your code

Sub test()
Dim WB As Workbook
Set WB = Workbooks.Open("C\test.xls")
MsgBox "By"
WB.Close True ' false = not save and true = save
End Sub

Or if the workbook is active use this line

ActiveWorkbook.Close True ' false = not save and true = save


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Will Fleenor" wrote in message ...
I need a macro that will open a file named DptBBudget.xls and close the curent file named DptBBudget.xls. I have no problem with
the file open part using the Workbooks.Open Filename:= "DptBBudget.xls" command. I am having a problem with the Workbooks.Close
command which appears to close all the open workbooks including the one I just opened.

Any help would be appreciated. I actually have a string of about 20 document I need to open, one just behind the other so
figuring this out would be very helpful. As I suspect you have figured out, I am not a programmer (I am an accountant) and any
help would be greatly appreciated.

Thanks, Will
Will Fleenor