Catching error when opening Excel file with same name

[snowmantle]

Hi,
In VBA if I do

Workbooks.Open fileName

If the user has a file with the same name already open is there a way to catch the error and ask them to change the selection rather than returning a debug message.. that only lets you end or debug the method?

 

[SkipVought]

Hi,

BEFORE opening the file, poll the Workbooks Collection to check the name.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[HarleyQuinn]

Also, some general error handling routine is worth adding in case anything else causes an error so it can be dealt with in a managed way rather than popping up the debug box to the end user.

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[PHV]

Have a look here:

http://www.xcelfiles.com/IsFileOpenVBA.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886