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
|