ADO queries are throwing errors that files are already open.

bfreescott

bfreescott

Board Regular
Joined
Aug 6, 2015
Messages
115
I have an ADO query that pulls data from other excel files (without opening them - thus, the reason for choosing ADO to begin with), but the queries are erroring out when the file being queried is already opened by another user. Have you seen this or been able to resolve it?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You must log in or register to reply here.

Similar threads

R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
140
rcrumbliss
R
O
  • Question
a file opening problem pulling the data from closed Excel with ADO method
Replies
5
Views
690
6StringJazzer
6StringJazzer
A
  • Solved
Copy Excel Table to a new workbook by removing all connections
Replies
9
Views
722
alishern
A
R
  • Question
Need to update tables in 2-open workbooks
Replies
0
Views
210
Rex2024
R
E
  • Question
From two dates, dividing the years into different columns, create hyperlinks organized by quantity and not by dates
Replies
0
Views
164
ExcelenteNovel
E

Forum statistics

Threads
1,215,752
Messages
6,126,672
Members
449,327
Latest member
John4520

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top