Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Data Exchange » Check if Excel Workbook is loaded when running MS Access

Check if Excel Workbook is loaded when running MS Access

Previous | Next
Latest post Sat, Mar 1 2008 6:08 PM by Anonymous. 1 replies.

  • Sat, Mar 1 2008 8:26 AM

    Check if Excel Workbook is loaded when running MS Access

    Reply |Contact

    Does anyone got a code snippet to check if a specific MS Excel workbook is loaded when working within MS Access environment?

    Many thanks

    Alastair

     
    Filed under:
    • Post Points: 5

  • Sat, Mar 1 2008 6:08 PM In reply to

    Re: Check if Excel Workbook is loaded when running MS Access

    Reply |Contact |Mark as Answer

    Function IsOpenXLWB(wbn As String) As Boolean
      On Error Resume Next
      IsOpenXLWB = Not (GetObject("Excel.Application").Workbooks(wbn) Is Nothing)
      Err.Clear
    End Function
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.