It's all about the answers!

Ask a question

Connect to RTC via Excel macro


Kavita Sanglikar (111) | 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.