Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is workbook open
Is there a simple way in VBA to determine if a workbook of a specific name
is open? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is workbook open
"big G" wrote in message
... Is there a simple way in VBA to determine if a workbook of a specific name is open? The following function returns True or False depending on whether the workbook name passed to it is an open or closed workbook: Public Function bIsBookOpen(ByRef szBookName As String) As Boolean On Error Resume Next bIsBookOpen = Not (Application.Workbooks(szBookName) Is Nothing) End Function Sub Demo() MsgBox "Is MyBook.xls open? " & bIsBookOpen("MyBook.xls") End Sub -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is workbook open
Dim wkbk as Workbook
On Error Resume next set wkbk = workbooks("MyWorbook.xls") On Error goto 0 if wkbk is nothing then msgbox "It isn't open" End if -- Regards, Tom Ogilvy big G wrote in message ... Is there a simple way in VBA to determine if a workbook of a specific name is open? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |