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

 

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