Reading Excel file when it is opened by excel application
 

Hi all,

please tell me how read excel file from .net when it is already
opened by another user using microsoft excel application.
i tried following

1] Using oledb
when file is closed i can read but when it is kept open i cannot
2] excel object
same as above

thanks in advance

Re: Reading Excel file when it is opened by excel application
 

Hi are you using recordsets? If so what is the locktype set to ? :)