ADO while being used

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Frank,

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

TOOLS > SHAREWORK > ALLOW CHANGES

Just a thought.

Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for copy 8
ADO to get Worksheet Name 1
Sorting Data 1
get a sequence number from . . . ? 2
ADO SQL syntax for extracting specific columns from Excel to Excel 3
Formula from closed workbook? 2
Using ADO With Excel 1
Limits in SQL query 3

Back
Top