[RESOLVED] Read an excel file thats open

Hi Guys,

I have an excel file (xls) (Excel 2003) which is open in microsoft excel. This file gets updated via a feed every few seconds. I need to write a vb.net program that will read data from that open excel file every x seconds.

My problem is how to read data from that already open file. The traditional file read routine which open and reads file won't work here as you will get error that file is already open in excel.

Is there any other way ?

Thank you,

Cheers,
GR

I found a way to do it using OLEDb adaptor.