Is File Open in Another Session

[SDruley]

Is there a way to check and see if a particular file is open in another session of Excel. I know how to open the file but lack the knowledge to check first if it is open.

[Paul]

Hi SDruley, perhaps this example will help you out:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=468

Hope it helps!

[snb]

That suggestion could be reduced to:

Please Login or Register  to view this content.

[SDruley]

It is amazing how Excel vba programming can be a measure of how deeply one can think through a solution. I am totally blown away by snb's response here. Sensational programming.

[Paul]

snb, since you already specified the variable c01 and set it to the file path/name, could you not use it in the IIf statement, e.g.

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

?

[snb]

@Paul,

Yes, of course. You are quite right. Thanks !
You triggered me not to use a redundant variable at all, resulting in :
Please scrutinize this as thoroughly as you did my previous suggestion.

Please Login or Register  to view this content.

Please scrutinize this code as thoroughly as you did my previous suggestion.