none
Send excel data to web using JSON in VBA RRS feed

  • Question

  • i want to export my excel data to web server using JSON. Can somebody please help me in sending the JSON Http request to web server in Excel VBA.
    Saugat K.C.
    Thursday, September 8, 2011 9:11 AM

Answers

All replies

  • i want to export my excel data to web server using JSON. Can somebody please help me in sending the JSON Http request to web server in Excel VBA.
    Saugat K.C.


    Search google for 'vba json' (w/o the quotes).  Or, see my post at

    http://www.dailydoseofexcel.com/archives/2010/03/15/language-detection/#comment-44588


    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present
    Thursday, September 8, 2011 6:00 PM
  • Dear Tushar, Thank you for your suggestion but here i would like to point out two different things.

    1. I have to send json data to web not extracting the json data from web. i was successful in extracting the data but i got stuck in sending the json data.
    2. I am sending the data to Redmine server rather than getting data from google server.


      Can you please help me out to get rid off this problem.
      Thank you

    Saugat K.C.
    Friday, September 9, 2011 6:56 AM
  • Hello

    Here are a set of VBA classes that get jSon data both in and out of Excel for use with web services. You will find downloadable examples of various implementations.

     

    http://ramblings.mcpher.com/Home/excelquirks/json

     

    Bruce


    ramblings.mcpher.com
    • Proposed as answer by danishaniModerator Tuesday, January 31, 2012 1:49 AM
    • Marked as answer by Saugat331 Tuesday, January 31, 2012 2:10 AM
    Friday, October 7, 2011 2:58 PM