Indicate when an excel workbook is open.

[Daybreak]

Hi all,
I was hoping u can give me a hand with a problem i'm having.I've managed to open an Excel app from vb.net but i wan't some sort of code that will indicate when a Workbook is open so that the program can save it automaticly.

[Shashi Sadasivan]

Hi all,
I was hoping u can give me a hand with a problem i'm having.I've managed to open an Excel app from vb.net but i wan't some sort of code that will indicate when a Workbook is open so that the program can save it automaticly.

Try using the System.Diagnost ics.Process to find if the application is open.

However, (and alternatively) excel locks the file if it is open (i know access does, excel should be doing the same). Maybe you can use that as a clue