Checking of workbook open

F

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
 
F

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
 
N

Norman Jones

Hi Freekrill,

Look at the first comment line in Dick's function:
'Returns True if workbook is open
Click to expand...

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
 
D

Dick Kusleika

Right. Poor choice of names on my part.

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

Norman Jones said:
Hi Freekrill,

Look at the first comment line in Dick's function:
'Returns True if workbook is open
Click to expand...

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
Click to expand...
 
Top