I believe Office 2007 Excel files can be configured for Sharing by concurrent users.
Does anyone know if TDA automation will successfully connect to a shared excel file while already open by another user?
If so, is there some specific configuration I need to setup?
I’m looking at creating an automated TDA report, which connects to a number of separate Excel workbooks (used by different work stream / departments) to take a snapshot/summary of how work is progressing on a weekly basis.
Unfortunately this snapshot is needed during normal working hours, so these Excel files maybe currently in use (open) be others.
Thank you in advance