Check Status of Excel Spreadsheet

[IanT]

Hi

I am using code to import data from a Excel Spreadsheet. Is there code that will check to see if the workbook is open or closed! I would like this to happen befor the import process starts.

Thanks in advance.

 

[reclusivemonkey]

The "IsOpen" property should work for you.