ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ADO while being used (https://www.excelbanter.com/excel-programming/392053-ado-while-being-used.html)

Frank Situmorang

ADO while being used
 
Hello experts:

I want to extract data from the workbook using ADO. My question is can we do
it while the workbook is being used by a user?. We have the workbook in the a
network which is a P.O. File, while other person want to update his databank
taking the data from this P.O line item.

Many Thanks,

Frank


Greg Glynn

ADO while being used
 
Hi Frank,

My suggestion is untested, but have you tried making the PO file
shareable?

TOOLS SHAREWORK ALLOW CHANGES

Just a thought.

Greg



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com