You got it. ;)

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Tom Ogilvy" wrote in message
...
Neither the OP's question or my suggestion was for a workbook opened in
the
same instance of Excel, so I assume this is some added information.

--
Regards,
Tom Ogilvy


"Zack Barresse" wrote in message
...
For a local approach, I generally take the easy two-liner..

Function IsWbOpen(wbName as string) as boolean
On error resume next
IsWbOpen = Len(Workbooks(wbName).Name)
End function

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Tom Ogilvy" wrote in message
...
If you don't care about who has the file open, you can modify Ivan's
code
or
just start out using this simple code (the guts of which is identical
to
the
approach used by Ivan).


http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open


--
Regards,
Tom Ogilvy


"Zack Barresse" wrote:

Ivan Moala has a solution to checking if a file is open on a network
or
not,
an API method and a VBA method he
http://www.xcelfiles.com/IsFileOpen.html

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Ian Elliott" wrote in message
...
Thanks for any help.
I have a macro (Excel 2000) in a workbook that copies and pastes
some
tabs
into the workbook it opens. But sometimes the files that it opens
are
already
open by another user. In that case, there is an error message and
some
other
stuff can happen that messes up the program. I would like to stop
this,
is
there any properties or code that I can do to tell if a file is
already
open?
I thought of using an On Error stuff, but is there another way?
Thanks again.