pulling a list of data from a shared Excel File

  • Thread starter Thread starter Usarian Skiff
  • Start date Start date
U

Usarian Skiff

I'm pulling a list of data from an excel file.

When I open Excel files directly, if someone else has it open, I can select
'READ-ONLY' from a pop-up.

When accessing the file from within my vb.net application, I don't get a
pop-up to ask me if read-only is acceptable, but I assume there is a setting
(in the connection string?) I could use to access the file as read-only if
the file does happen to be in use.

Anybody know?
Thanks!
Usarian M. Skiff
 
Hi,

Maybe you can use ado.net to get the data
http://support.microsoft.com/default.aspx?scid=kb;en-us;316934

Ken
-----------------------
I'm pulling a list of data from an excel file.

When I open Excel files directly, if someone else has it open, I can select
'READ-ONLY' from a pop-up.

When accessing the file from within my vb.net application, I don't get a
pop-up to ask me if read-only is acceptable, but I assume there is a setting
(in the connection string?) I could use to access the file as read-only if
the file does happen to be in use.

Anybody know?
Thanks!
Usarian M. Skiff
 
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

Excell 2021 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel How to Fix Damaged Excel File That Won't Open? 3
Excel Unlink open excel files 2
Trouble pulling data from Excel file 2
How to subtract a number from a Mergefield? 0
Mixing lists 1
Excel cannot find or read file 5

Back
Top