It's all about the answers!

Ask a question

Connect to RTC via Excel macro


Kavita Sanglikar (1111) | asked May 14 '18, 1:50 a.m.

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


Comments
Rohini Kumar commented May 14 '18, 2:33 a.m. | edited May 19 '18, 12:02 a.m.

 Can you please give more description on it?


Kavita Sanglikar commented May 14 '18, 3:40 a.m. | edited 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 commented May 14 '18, 5:11 a.m.

 You need to call shellExecute in VBA to connect RTC via macro 


Kavita Sanglikar commented 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

One answer



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.