Symantec Access Management

  • Private Community

  • 1.  Is it possible make REST call from Excel Macro?

    Posted Nov 24, 2017 02:03 AM

    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



  • 2.  Re: Is it possible make REST call from Excel Macro?
    Best Answer

    Broadcom Employee
    Posted Dec 08, 2017 07:13 PM

    Yes it is possible. Please refer the following link:

    http://www.automateexcel.com/2004/11/14/excel_vba_consume_web_services/ 



  • 3.  RE: Re: Is it possible make REST call from Excel Macro?

    Posted Feb 24, 2020 07:58 AM
    While making the API call from Excel VBA, is it possible to include Layer & authentication between API and Excel and get back the results from API and store in Excel.
    Original Message


  • 4.  Re: Is it possible make REST call from Excel Macro?

    Posted Dec 09, 2017 10:24 PM

    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 



  • 5.  RE: Re: Is it possible make REST call from Excel Macro?

    Posted Feb 24, 2020 08:10 AM

    Yes, I saw that. The question here is not just invoking the API the flow is as follows,

    Excel -> Layer 7(broadcom)-> API and then

    API -> Layer 7(broadcom)- -> Excel

    I just need to know if this is feasible solution. since our organization uses Layer 7 for security.


    Original Message