I am unable to co-author a VBA program due to Microsoft limitations, so I want to run 2-seperate copies of the program and have each one pull an updated table from the other occasionally.
The problem is both workbooks will be open at the time and I get the following error:
Details: "The process cannot access the file 'C:\Users\######\OneDrive\Tracker.xlsm' because it is being used by another process."
Is it possible to update a table using a query from another user while their workbook is open? If so, how?
If it isn't possible, what solutions do I have to sync tables with 2-open workbooks?
Thanks.
The problem is both workbooks will be open at the time and I get the following error:
Details: "The process cannot access the file 'C:\Users\######\OneDrive\Tracker.xlsm' because it is being used by another process."
Is it possible to update a table using a query from another user while their workbook is open? If so, how?
If it isn't possible, what solutions do I have to sync tables with 2-open workbooks?
Thanks.
