Check if a excel file is open

[dzogchen]

You need to go to tools / references and the select the Microsoft Excel XX.X object library in the vba editor. I thinks it's early vs late binding depending on what you want to use.

Thank you for the information!!

Thank you alot gmayor!! It worked! I have just changed the condition "xlApp.Visible = False" to True and disabled the "MsgBox xlBook.sheets(1).Range("A1")"

Any ideas to put the excel file as maximized window because it appears as a thin minimized window? I have tested the code with "xlBook.Application.WindowState = xlMaximized" next to "Set xlBook = xlApp.workbooks(strWB)" and it didn't worked.

Thank you

I have figured it out already!

in the excel file I put:

Private Sub Workbook_open()

Application.WindowState = xlMaximized


End Sub

Thank you all for the Help

Regards