You can't have two workbooks open with the same name, so it is unclear how
you are not having trouble with Workbooks.Open.

While Open is qualified by Workbooks, close is qualified by a specific
workbook (unless you wanted to close all workbooks which it appears you
don't)

Workbooks("DptBBudget.xls").Close

would just close DptBBudget.xls

--
Regards,
Tom Ogilvy


"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