Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have the following simple program to save all programs
(the first one). i now want the program to close all sheets. i realize that there is the 'application.quit' function, but i dont want to close EXCEL. the problem with the second program below is that the first sheet is the one with the program, once it closes the prgram obviously stops. im sure there are many ways of doing this... For Each w In Application.Workbooks: w.Save Next w For Each w In Application.Workbooks: w.Close Next w |