Checking of workbook open

[freekrill]

Hi,

I ithink I have read before how to do this, but I can't locate th
informatioin now that I need to use it.

In my code, I wish to activate a workbook (which most of the time wil
already be open), or open and activate it if it is not open.

Can someone tell me what to write?

Cheers
fre

 

[Dick Kusleika]

free

Here's one way

http://www.dicks-blog.com/excel/2004/05/workbook_exists.html

 

[freekrill]

Thanks Dick,

My problem is that I know the Workbook exists, I just need to check i
the particular workbook is open.

Thanks
fre

 

[Norman Jones]

Hi Freekrill,

Look at the first comment line in Dick's function:

'Returns True if workbook is open

You may know that the *file* is resident on you drive, but your file only
becomes a workbook - a member of the Workbooks collection - when it is open.
If the workbook is on the drive but is not open, the function will return
False.

In short, use Dick's function to check if the workbook is open

 

[Dick Kusleika]

Right. Poor choice of names on my part.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

Hi Freekrill,

Look at the first comment line in Dick's function:

'Returns True if workbook is open

You may know that the *file* is resident on you drive, but your file only
becomes a workbook - a member of the Workbooks collection - when it is open.
If the workbook is on the drive but is not open, the function will return
False.

In short, use Dick's function to check if the workbook is open