Hello,
We have a requirement to call a REST service from excel Macro / VB code. Is it possible to make REST service call? Any help in this is appreciated..
Thanks
M.G.HEGDE
Yes it is possible. Please refer the following link:
http://www.automateexcel.com/2004/11/14/excel_vba_consume_web_services/
Not sure if you saw this already. Following link should help you with what you are looking for - How to make REST call with VBA in Excel? - Stack Overflow
Yes, I saw that. The question here is not just invoking the API the flow is as follows,Excel -> Layer 7(broadcom)-> API and thenAPI -> Layer 7(broadcom)- -> ExcelI just need to know if this is feasible solution. since our organization uses Layer 7 for security.