dynamically close an Excel workbook

[barnard90]

Hi
I have an excel sheet C:\Employee.xls
I need to close it dynamically from an another Excel sheet
How do I do that

First I need to check if C:\Employee.xls
is open or not. If it is opened , it has to be immediately closed

Could some one please sugest the code

thanks

 

[SkipVought]

Hi,

Assuming that the workbook in question is open in the active instance of Excel...

 Workbooks("Employee.xls").Close

Skip,

_[red][/red]