How to find out who has the workbook opened when open file via Macro

[littlek]

Any suggestion to the problem is very much appreciated.

When opening a workbook currently being modified by another user via a macro, Excel opened the file with Read-Only, without prompting with details as to who has the workbook opened.

Is it possible to make the macro to pop up a message box to say who currently has the workbook opened?

Thanks.

 

[xlbo]

That's a little odd as usually, the read only messgae is accompanied by
"this workbook is currently being modified by userID do you want to: etc etc"

The userID would be whoever has the book open

Are you sure there is no message like this ?? Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[littlek]

Thanks for taking the time to reply my thread.

Yes, when you open a workbook that is currently being modified by another user by a macro, Excel just goes ahead and opens the workbook with Read-only right.

Thanks.

 

[xlbo]

aaaah - sorry my misunderstanding - didn't read the bit about opening the file thru code
Will look into this and see if I can find anything but I have a feeling you will need an API call (unless you are using a newer version than '97 and there is a workbook property for this - there isn't in 97 AFAIK) Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[littlek]

Thanks, Geoff.

You are a true hero. Looking forward to your findings.

Littlek