ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create Object (https://www.excelbanter.com/excel-programming/291991-create-object.html)

Gillian[_2_]

Create Object
 
Hi,

I'm trying some OLE code out but have a problem, this is
the line I'm using.

Set ImpAppObject = CreateObject("BI-Query
User.Application")

The question is BI-Query User is an application I want
control. It appears as "BI-Query User" in my Windows Start
menu but exactly how do I refer to it in this line?
Is there a way of finding out how you refer to application
in this line?

All and any help most appreciated ! !

Tom Ogilvy

Create Object
 
The first question would be to know if it supports OLE Automation.

If it does, then you would have to refer to it by its ProgID. You can
search the registry for the executable name and find the GUID. In the same
area, you should then be able to find an entry for its program ID.

However, I think if it does support Automation, the documentation or the
author of the code should be able to provide information on how to call and
reference it. In any event, if you go to Tools=References in the VBE, it
should be shown there - you can create a reference to it and look at its
objects, properties and methods in object browser.

--
Regards,
Tom Ogilvy

"Gillian" wrote in message
...
Hi,

I'm trying some OLE code out but have a problem, this is
the line I'm using.

Set ImpAppObject = CreateObject("BI-Query
User.Application")

The question is BI-Query User is an application I want
control. It appears as "BI-Query User" in my Windows Start
menu but exactly how do I refer to it in this line?
Is there a way of finding out how you refer to application
in this line?

All and any help most appreciated ! !





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com