It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,034
×233
×91
×64

question asked: Jan 16 '14, 11:35 p.m.
question was seen: 6,570 times
last updated: Jan 21 '14, 2:50 a.m.

Related questions

Creating session using ClearQuest API on 64bit-Windows results ActiveX error.(by VBA)

0
Ayumi Matsuura (1●1●1) | asked Jan 16 '14, 11:35 p.m.
edited Jan 16 '14, 11:39 p.m.
I ran ExcelVBA creating CQsession, and it resulted in ActiveX error.

< VBA Code>
Set objSession = CreateObject("CLEARQUEST.SESSION")

< Error >
429: ActiveX component can't create object

< environment>
Excel 2010
Windows7-64bits
ClearQuest V8.0.1

I found this page below, but the way to resolve didn't work for VBA. (It's for VBScript)
http://www-01.ibm.com/support/docview.wss?uid=swg21447229

Has anyone found a way to create session of CQ from VBA on Windows-64bit? 


Thanks,

Ayumi

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Donald Nong (14.5k●6●14) | answered Jan 17 '14, 12:43 a.m.
Is your Excel 2010 64 bit or 32 bit? If 64 bit, you need to do some debugging to find out your own solution.

You can use the technote as a guideline. Basically the 32 bit executable and 64 bit executable look in different places of the Windows registry, and you need to know where it is looking and how to tell the application to look elsewhere.

Use Process Monitor to identify all the registry keys being read by Excel. Whether you can and/or how to tell Excel to check a different registry key, you will need to ask Microsoft.

Also, this is a ClearQuest question and you'd better ask the question in the ClearQuest forum.
https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000329
Comments
Ayumi Matsuura commented Jan 21 '14, 2:50 a.m.

My Excel 2010 is 64 bit.

Is C:\Windows\SysWOW64 the right place that the application look in?

And I'll ask the question in the ClearQuest forum.

Thank you.

Ayumi Matsuura commented Jan 21 '14, 2:50 a.m.

My Excel 2010 is 64 bit.

Is C:\Windows\SysWOW64 the right place that the application look in?

And I'll ask the question in the ClearQuest forum.

Thank you. 

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.