Guys,

I need some real help in making a connection between excel and Web API .

I do not know much of coding and cant write one. Hence is suggestions in a bit simple language. Excuse me for that.

Scenario that I have is

I have a VBA excel based straight create click based interface. Created with help of drag and drop facilities.
I am trading vendour whose API is web based.

My question is
How can I create a link between VBA excel based interface and the web based API?
What are the details required?
Suggests links/articles/websites/forums/etc, if any , which provides detail answer(s)

Please come up with any thought(s)/suggestion(s)

Which API is it ?
If it is something using Java/Flash, it's nearly impossible to connect those, it's only doable with "real" html (get/post/...).

Hi Sam028,

You are right its Java flash based API.
Do you mean that its still possible when HTML is used to connect? Can you kindly provide some lead to start with?

Thank you
Gunjan

sam028 

Which API is it ? If it is something using Java/Flash, it's nearly impossible to connect those, it's only doable with "real" html (get/post/...).