Check the name of user if workbook open

**JCabral** · 05-20-2020, 01:58 PM

Good afternoon

I need to get data from a specific file.

For this I need to know if it is open by another user and if so what is the user's name.

The path where the file is located is of type, PathStressDB = "\\Aptr.pt\srv125\DDD-Railw\5 - Planning\5.4 - Maps_DPE\01_DRR_Situations.xlsx", that is, it is on a server and not on the machine where I am working.

Can you help me with the VBA code to, in a first stage, check if the file is open by a user, and if so, what is the user's name?

Thank you

Jorge Cabral

Note: Also in - OzGrid https://www.ozgrid.com/forum/index.p...41#post1235741

**JCabral** · 05-21-2020, 07:29 AM

I found this function on the net - https://wellsr.com/vba/2018/excel/fi...ting-with-vba/ - made by Philip Hanebeck

Please Login or Register  to view this content.

It is not working and I cannot adapt to my case.

The error that the function gives is on the line :

Please Login or Register  to view this content.

Run-time error '-2147217406 (80041002)'; not found

Any help in adapting this function?

Thanks

Jorge

**JCabral** · 05-27-2020, 07:37 AM

A small correction to what I mentioned in the post above, the function, does not run correctly for my specific case, that is, when the file is somewhere on a server.

When the file is on the local disk the function works correctly.

Any help to resolve this issue is welcome.

**crookesa** · 09-04-2020, 07:18 AM

Originally Posted by JCabral

A small correction to what I mentioned in the post above, the function, does not run correctly for my specific case, that is, when the file is somewhere on a server.

When the file is on the local disk the function works correctly.

Any help to resolve this issue is welcome.

JCabral, did you get this working. I also have the same problem when my file is on a server and the path begins with '\\'. If the same file is server is mapped to a drive eg. j: then the function above works.
I am still not able to get it to work if it's on a server.

It would be great to find a solution

**JCabral** · 09-04-2020, 09:59 AM

Hi Crookesa

I couldn't solve my problem. My problem is precisely yours.

I'm very new to this VBA so I can't help it, and it seems that the problem is not very easy so only a vba expert can help.

If you get a solution, I ask you to share it here.

**alansidman** · 09-04-2020, 10:03 AM

Administrative Note:
@crookesa
Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Check the name of user if workbook open

LinkBack

Thread Tools

Rate This Thread

Display

Check the name of user if workbook open

Re: Check the name of user if workbook open

Re: Check the name of user if workbook open

Re: Check the name of user if workbook open

Re: Check the name of user if workbook open

Re: Check the name of user if workbook open

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] vba to open excel workbook if alrady open by other user show userform and exit sub

[SOLVED] Check for existing File name, open if exist or open new workbook if not

[SOLVED] Macro to open workbook with a suffix (need help to check if file is already open)

[SOLVED] Check If workbook not open then open workbook and run code

[SOLVED] VBA UserForm.Value Check If User Form Buttons checked Not Working. Check Button on Open.

VBA to check if user has pdf file open

updating the master workbook whenever user click submit in check workbook

Bookmarks

Bookmarks

Posting Permissions