Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Access an AWS API service from Excel VBA?

0

Hello, I’ve been trying for a long time to access AWS API service directly from Microsoft Excel. I am using native VBA in Microsoft Excel and having trouble making the connection to pass the correct headers. I have tried the AWS 4.bas However, still having problems is there any guidance on how to do this? Or does anyone have example code?

Topics
ServerlessDevOpsFront-End Web & MobileNetworking & Content Delivery
Tags
Amazon API GatewayDevOps
Language
English

asked 2 years ago1.1K views

1 Answer
1

Why do you need to sign the header? If you use the SDK the client takes the heavy lifting of signing the request. Please check this example: https://repost.aws/questions/QUZGnK_EfXS2OoApuhWQ0Bfw/amazon-s3-using-excel-vba

AWS

answered 2 years ago

  • Cfitt
    2 years ago

    Thank you , I will try it. (Fairly newbie here so thank you). Secondary question , will every user that uses this macro when I have made it and inserted into an Addin for others to use also need SDK installed ? Or will it be self sustaining ?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content