Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Connect to RTC via Excel macro

Questions
Tags
Users
Badges
Kavita Sanglikar
(11●1●1) May 14 '18, 1:50 a.m.

Hello, can anyone help me connect to RTC via Excel macro VBscript?

0 votes

Comments
Rohini Kumar
May 19 '18, 12:02 a.m.
 Can you please give more description on it?

Kavita Sanglikar
May 19 '18, 12:02 a.m.
I want to connect to RTC and query workitem details via Excel macro (VBScript program by connecting to object and query all the details) Be it a VBScript (OSLC and  REST API) or Java program(OSLC), any one technique would be fine to work on.

Rohini Kumar
May 14 '18, 5:11 a.m.
 You need to call shellExecute in VBA to connect RTC via macro 

Kavita Sanglikar
May 14 '18, 7:54 a.m.
Thanks Amruta.. It would be of great help if you could share a sample script for this point, as I am struggling a lot to connect to RTC via VBA in Excel

1 answer
6,185 views
0 votes

One answer

Permanent link
Rohini Kumar
(92●1●10●57) May 14 '18, 9:36 a.m.

 Hi Kavita ,

     refer below link :

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 11,105

Question asked: May 14 '18, 1:50 a.m.

Question was seen: 6,185 times

Last updated: May 19 '18, 12:02 a.m.

Confirmation Cancel Confirm