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

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

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