How to tell if a workbook is open

[suburbanght]

I have created a subroutine that moves a sheet from one workbook to another, but sometimes the destination book is open and sometimes it isn't. I don't want to always run a line to open the destination workbook as it causes an error if it's already open. Is there a way I can test to see if the workbook is open?

Thanks.

[VBA Noob]

Links should help

http://www.ozgrid.com/VBA/IsWorkbookOpen.htm

http://www.exceltip.com/st/Determine...Excel/472.html

VBA Noob

[royUK]

Here's a Function to do it. Place this code in a Standard Module

Please Login or Register  to view this content.

Use it like this, cahnge YourWorkbook to the name of your workbook

Please Login or Register  to view this content.