Hi

Is there any way I can check if a specific workbook, e.g. book1.xls, is open?
I've been trying to do something like this;
VB Code:
  1. If book.xls exist then 'This is the line that bothers me!
  2. 'code
  3. else
  4. workbooks.add 'creating book1.xls
  5. 'code
  6. end if

I know i've posted a smiliar question earlier, but hopefully by rephraising it someone can help me

Thanx
Nick