Press enter when alert pops up in excel

[Martins88]

I use ActiveWorkbook.Lockserverfile procedure in excel 2016

When I run my macro and the file with this procedure(ActiveWorkbook.lockServer) opened in another computer I get a an alert : enter image description here



CHECK001.PNG
I want that "enter" button will be pressed automaticaly so that file will opened as read only.

I open for other suggestion like turn off the alerts (didn't work)


I posted same in other forums but didn't get anwer

https://stackoverflow.com/questions/...ps-up-in-excel

http://www.ozgrid.com/forum/showthre...goto=newpost**

[sweep]

Hi,

DOes this help at all?

Please Login or Register  to view this content.

It's worth taking a look here. Which suggests that notify must be set to true, otherwise trying to open an in use file will fail.

If the file cannot be opened in read/write mode, this argument is True to add the file to the file notification list. Microsoft Excel will open the file as read-only, poll the file notification list, and then notify the user when the file becomes available. If this argument is False or omitted, no notification is requested, and any attempts to open an unavailable file will fail.

[Martins88]

Hi,

DOes this help at all?

Please Login or Register  to view this content.

It's worth taking a look here. Which suggests that notify must be set to true, otherwise trying to open an in use file will fail.

No. I want to open this file for editing and if this file locked in another station I want to proceed to next file without press ok (vba needed cause I not near the comp where this happened )

[sweep]

Check if the file is open before you attempt to open it. There is an example of how you can do that at the following page

https://stackoverflow.com/questions/...s-already-open