Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro to Close Word File | Excel Discussion (Misc queries) | |||
Macro to save and close, then copy file | Excel Discussion (Misc queries) | |||
How to close a excel file using Macro coding? | Excel Worksheet Functions | |||
Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |