GetObject returning an error if the file is already open

Hello to all,

I have 2 Excel Workbooks (DataBase.xlsx and Program.xlsm)

DataBase.xlsx is a shared file located on a shared folder (Teams/Sharepoint). Program.xlsm is an Excel file located on user's PC.

Any User can insert and retrieve Data from the DataBase.xlsx.

I am using GetObject to open with an invisible way the DataBase.xlsx each time that a user wants to Add Or fetch Data.

The problem is that if the DataBase is already opened, the GetObject fails and returns an error : "File name or class name not found during Automation operation", but if it's already closed and I call GetObject there is no problem and the code works fine.

Also, if I place the DataBase.xlsx on a local folder (not the shared one), even if it's already opened I can still call the GetObject without any problem.

Is there anyway to solve this and to allow users to save and fetch data from an excel even if it's already opened by another one ?


Here is the part of my code where I am facing the problem :

Please Login or Register  to view this content.

Hello,

not on VBA side with GetObject - or check first if the workbook is already opened - as it well works when not on Sharepoint
so Sharepoint seems to lock the opened workbook … What the IT says ?

Yes in case of a direct attempt but useless with a smart enough code just checking each name from the Workbooks collection …