excel - Running VBA on AWS

Question

I am totally a novice when it comes to cloud computing. I want to run a VBA code that performs some calculations and excel operations on an excel file . I want to deploy this code in AWS server and run this VBA code on 600+ excel files located across 4 different local machines. Is this even feasible? I couldn't find anything meaningful(or maybe I did but did not understand) clue towards solving this problem. Please help me .

question from:https://stackoverflow.com/questions/65831318/running-vba-on-aws

Answer 1

AWS does not expose a VBA lib. However, if you are interested in .NET development, you should use the AWS SDK for .NET. You can find examples in the Github repo located here:

https://github.com/awsdocs/aws-doc-sdk-examples/tree/master/dotnet3.5

If you want to manipulate Excel files, look at using a .NET Excel lib. Then you can write logic on the cloud that uses the .NET lib. Purhaps write a Lambda function.