"Post" method not working while using API in VBA



I want to update values in smartsheet using API Key but post method is not working.


Sandhiya P


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Sandhiya07

    I haven't had experience with VBA at all, but from what I found on the internet it looks like VBA may only give you API access to update Microsoft related products. Here's the article I found.

    I'd suggest testing your calls in Postman to see if you're able to Post to Smartsheet in general.



  • Sergio G.

    Hey! I hope the information below is useful to you and to anybody working with VBA since the information available is limited to none. I personally myself work a lot with VBA Excel and had to figure this one out.

    Follow the Code Formatting and replace values with your personal information. Make sure you run a GET Request first so you can get rowIDs and whatnot.