VB(A) Interaction with Cognos 1

[JerryKlmns]

Referencing
Excel Interaction with Cognos: thread401-774314

Is there a nice lib for Cognos Impromptu, in order to add it to references in VB(A), to get the lovely Intellisense and the object model (xlbo )

I tried in Cognos forum
Impromptu Log On Info. Prompt the user: thread401-1279510
but No answer found to display!

 

[xlbo]

Hi Jerry - never found the dll I'm afraid but re-reading the thread it seems like you should just need to tick the appropriate reference......

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JerryKlmns]

Hi Geoff,

Found that DLL, but it has to do with ... Excel. Besides that an error says : Can't add reference to the specified file
Same goes to excelrendererclient_71.dll (Cognos 7)

I was looking for Access and VB. I'll keep trying and post back.

Thank you!

 

[misterstick]

the file you want is:

C:\Program Files\Cognos\cerN\bin\impclient.tlb

where cerN is version dependent; i'm on version 7.3 and it's cer4 for me.

be aware that the create functions don't return the objects you expect, so you'll have to declare them as the real type at design time to get intellisense, but change them over to type object just before runtime otherwise it won't compile.

'won't compile, will give intellisense
'Dim app As ImpromptuApplication
'will compile, no intellisense
Dim app As Object
Set app = CreateObject("Impromptu.Application")
app.Quit

mr s. <

 

[JerryKlmns]

Well misterstick you made my day!

 

[xlbo]

nice - we've pretty much got rid of cognos now but thanks for the input

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JerryKlmns]

Lucky you! Which crayon did you use?

 

[xlbo]

- we used a SQL Server Reporting Services flavour crayon !!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question