How to open a excel file using active X application in read only mode

[cancancanopen]

Hello,

I have an application which dumps all the data in local PC, I need to modify the program, the file will be saved in the network drive. Concerned people will be accessing the file, so when the file is opened by concerned person, my application cannot write data into the file as i grt file already opened error.

1. How to open a excel file using active X application in read only mode, and view that in full screen mode.

2. How to apply password to the excelfile when i create excel using report eneration toolkit.

3. Is there any other method, from which I come to know that a file has already opened prior to writing the data.

Thanks

[smercurio_fc]

Are you asking in general how to read an Excel file using ActiveX, or are you asking specifically? If you're asking in general, please do a search, as there have been many examples posted on how to use ActiveX to read/write Excel files. There are also numerous links in the Excel thread.