can anyone tell me how to get a list of the object classes
registered on any given PC?

the ones that would be used in:

Dim objApplication
Set objApplication = CreateObject("Excel.Application")


the object classes that are recognized on a given pc with
the CreateObject function.

Thanks.

You can look them up in the registry, under HKEY_CLASSES_ROOT... it's quite
a long list...

--
Regards

Juan Pablo González

"mark" wrote in message
...
can anyone tell me how to get a list of the object classes
registered on any given PC?

the ones that would be used in:

Dim objApplication
Set objApplication = CreateObject("Excel.Application")


the object classes that are recognized on a given pc with
the CreateObject function.

Thanks.

it's quite a long list...

yep.
Thanks.

Mark,

You can find them in the Registry under the HKEY_CLASSES_ROOT hive.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mark" wrote in message
...
can anyone tell me how to get a list of the object classes
registered on any given PC?

the ones that would be used in:

Dim objApplication
Set objApplication = CreateObject("Excel.Application")


the object classes that are recognized on a given pc with
the CreateObject function.

Thanks.

There's a pc that has 2 versions of Cognos Impromptu on
it... Version 5, and Version 6.

When a macro calls CreateObject("Impromptu.Application") ,
it brings it up in version 6.

I was looking into making it call version 5.

But it looks like it would be really involved.

-----Original Message-----
Mark,

You can find them in the Registry under the
HKEY_CLASSES_ROOT hive.

--

HTH

Try with

CreateObject("Impromptu.Application.5")

--
Regards

Juan Pablo González

"mark" wrote in message
...
There's a pc that has 2 versions of Cognos Impromptu on
it... Version 5, and Version 6.

When a macro calls CreateObject("Impromptu.Application") ,
it brings it up in version 6.

I was looking into making it call version 5.

But it looks like it would be really involved.

-----Original Message-----
Mark,

You can find them in the Registry under the
HKEY_CLASSES_ROOT hive.

--

HTH

CreateObject("Impromptu.Application.5")

Thanks for the idea...

I meant to say Impromptu 7.1 earlier, not Imp6

But anyway, using automation, both

CreateObject("Impromptu.Application") , and
CreateObject("Impromptu.Application.50")

bring up Imromptu 7.1

"Impromptu.Application.5" results in 'bad object class'

I did find the registry key that causes it to think it
should go to Imp7.1, and changed that, but then it just
threw me into a 'server is busy' loop and didn't really
bring anything up, so I changed it back and now it is
working as it was.

Mark,

Tom Ogilvy has already made this point, so I am just re-iterating

... aversion number .. on the end does nothing according to articles
published by Microsoft. The last version registered will be the version
used by GetObject and CreateObject.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mark" wrote in message
...
CreateObject("Impromptu.Application.5")

Thanks for the idea...

I meant to say Impromptu 7.1 earlier, not Imp6

But anyway, using automation, both

CreateObject("Impromptu.Application") , and
CreateObject("Impromptu.Application.50")

bring up Imromptu 7.1

"Impromptu.Application.5" results in 'bad object class'

I did find the registry key that causes it to think it
should go to Imp7.1, and changed that, but then it just
threw me into a 'server is busy' loop and didn't really
bring anything up, so I changed it back and now it is
working as it was.