Checking whether sheets are already open

bobeuk · Feb 22nd, 2002, 10:59 AM

I am writing a spreadsheet which opens and updates other books. I need to build an error trap which checks first whether the target workbook is open (and if so I wil then not open it). Is there a flag which shows active workbooks?

Cheers

John

Jack in the UK · Feb 22nd, 2002, 11:52 AM

Hi --

A great pal has some good stuff on this Dave Hawley try VBA section on http://www.ozgrid.com

Rdgs
==========
Jack

PS this is a good site.. might check Barrie Davidson site hes in the member section of this board, som every nice stuff there

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 10:59 AM	#1
bobeuk New Member Join Date: Feb 2002 Posts: 10	I am writing a spreadsheet which opens and updates other books. I need to build an error trap which checks first whether the target workbook is open (and if so I wil then not open it). Is there a flag which shows active workbooks? Cheers John

Feb 22nd, 2002, 11:52 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi -- A great pal has some good stuff on this Dave Hawley try VBA section on http://www.ozgrid.com Rdgs ========== Jack PS this is a good site.. might check Barrie Davidson site hes in the member section of this board, som every nice stuff there