I usually create an excel application from VB as follows:
Private myXLBook As Object
Set myXLBook = CreateObject("excel.application")
myXLBook.Visible = True
myXLBook.Workbooks.Add
However, instead of this I want to check if excel is already running and if it is I want to create a workbook instead of another excel application. How do you do this?
Thanks in advance
