Hi,

if checkForBook = false then workbooks.open jbl


-----Original Message-----
How do check to see if a workbook's open, and if it's
not already open,
then open it?

I've looked in the forum, but nobody seems to be looking
for the above
condition.

I've got this already:

jbl = "Production Schedule 040512.xls"
checkForBook = CBool(Len(Workbooks(jbl).name))

If Not checkForBook Then

'What goes here?'

End If


---
Message posted from http://www.ExcelForum.com/

.