1 liner

[Jackeb]

quick 1 liner required

what statment should i use to test weather or not a workbook is open??

Cheers

Ed

 

[StewartS]

Hi

I posted a similar question on 12 April the reply works fine.

Stewart

 

[Jackeb]

cheers

 

[Ivan F Moala]

On 2002-04-26 03:27, Jackeb wrote:

quick 1 liner required

what statment should i use to test weather or not a workbook is open??

Cheers

Ed

If you want a 1 liner then try;<pre/>
On Error Resume Next: Set IsOpen = Windows("Book4"): MsgBox Not IsEmpty(IsOpen)</pre>





_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font></font></font><A HREF= "http://www.gwds.co.nz/"><font color="green">http://www.gwds.co.nz/excel_files.html - Under Constru
This message was edited by Ivan F Moala on 2002-04-26 05:27

 

[Jackeb]

that is great.... thanx