List of open workbooks
 

is there a function or property that I can use that will give me a list of
all open work books currently running in excell 2003? I would like to know
what books are open so that my macro can close them if need be.

Thank you
Josh

List of open workbooks
 

for each bk in Application.Workbooks
msgbox bk.Name
Next

--
Regards,
Tom Ogilvy

"Josh" wrote in message
...
is there a function or property that I can use that will give me a list of
all open work books currently running in excell 2003? I would like to
know
what books are open so that my macro can close them if need be.

Thank you
Josh

List of open workbooks
 

That was easy. thank you

Josh
"Tom Ogilvy" wrote in message
...
for each bk in Application.Workbooks
msgbox bk.Name
Next

--
Regards,
Tom Ogilvy

"Josh" wrote in message
...
is there a function or property that I can use that will give me a list
of
all open work books currently running in excell 2003? I would like to
know
what books are open so that my macro can close them if need be.

Thank you
Josh