View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Will Fleenor Will Fleenor is offline
external usenet poster
 
Posts: 25
Default close file macro

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