When importing data from excel to vb.net desktop application, Im having "file is open" error.
Excel file is at the remote pc. Excel file must open and I have to reach anytime.
How can I handle this problem?
same error occured
Jack
2010-03-06 20:54:39
that can't be right, can you post some code ?
Iulian
2010-03-06 22:50:57
@PeaceKeeper you can't copy a file if something else has exclusive access to it.
msarchet
2010-03-27 00:32:39
A:
When Excel opens a file, it requests exclusive access. You should be able to access the same file if, when you open it, you open it in read-only mode and you allow both read sharing and write sharing.
Tim Robinson
2010-03-07 10:53:38