Excel file opened

[Fernando]

Hello,

How can I know if an excel file is being accessed by
another user, in Visual Basic for excel? Is there a global
constant or something that idicates this?

Thank you

 

[Guest]

-----Original Message-----
Hello,

How can I know if an excel file is being accessed by
another user, in Visual Basic for excel? Is there a global
constant or something that idicates this?

Thank you
.

If it is 'Shared' you can simply look in the list of
current users. If it isn't shared, maybe just share it
for a while and continually check the list to see if
anyone else is opening it up.

If you don't want to have others opening it up, then you
should probably 'protect' the workbook with a password.

Both Sharing and Protecting are built in functions that
you can find under 'Tools'. Conveniently, they are placed
right next to each other in the list.