Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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 ! !
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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 ! !



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add to insert object create new list Woapalanne Excel Discussion (Misc queries) 1 March 25th 10 02:51 PM
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
CREATE LIST OBJECT IN EXCEL MIKE Excel Worksheet Functions 0 June 20th 05 08:13 AM
MAPI create object error Dim Excel Programming 0 November 24th 03 07:08 PM
How do I create a Worksheets object Tony Lin Excel Programming 2 August 22nd 03 11:26 AM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"