WorkbookQuery.Application property (Excel)
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application.
When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
expression.Application
expression A variable that represents a WorkbookQuery object.
This example displays a message about the application that created myObject.
Set myObject = ActiveWorkbook
If myObject.Application.Value = "Microsoft Excel" Then
MsgBox "This is an Excel Application object."
Else
MsgBox "This is not an Excel Application object."
End If
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.