stdVBA VS VBA-Web

I do RPA from VBA personally using IAccessiblity. See stdAcc (https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls) and an example (https://github.com/sancarn/stdVBA-examples/tree/main/Example...)

You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....

The responses I got was a mix. Some businesses didn't take me seriously because the main language I used was VBA. Some businesses claimed I was too eager and I "didn't have a life". No one seemed to care about the achievements I had made in the languages, like building a DSL in VBA, or this electron app. I did eventually get a job in another engineering firm though, where I spend 90% of my time to this day programming.

Really depends what you actually want to do and how neat (or fast) you want your code to be too... I typically use stdEnumerator and stdLambda from stdVBA.

Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples

That said it is effort. After building stdLambda which brings lambda syntax to VBA, I can tell you that error handling in this class is still trash. It's just a lot of effort to write good error messages, and handle all errors correctly. Still definitely an item on the TODO list, but will it ever be a priority? idk

Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.

If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)

Use stdVBA's stdAcc:

Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.

Power query may or may not be suitable depending on the way that the API needs to be queried. VBA could also work but doesn't have great libraries available for working with standard web content. You could look at 3rd party VBA library like https://github.com/VBA-tools/VBA-Web .

Have you looked at the example for Twitter in this VBA GitHub?

No examples of connecting to SalesForce itself but many examples of how to use VBA-Web to ping REST APIs. I don't find VBA-Web too intuitive, but hope it helps anyhow :)

If you find you need to work with the SharePoint API's like Microsoft Graph https://learn.microsoft.com/en-us/graph/overview then you will need to be able to make web requests and process the responses. The VBA ecosystem is not really designed to work with content on the internet. It can be done via e.g. WinHTTP https://learn.microsoft.com/en-us/windows/win32/winhttp/about-winhttp or VBA-Web https://github.com/VBA-tools/VBA-Web

Interesting question, otherwise you'll have to re-code to e.g. https://github.com/VBA-tools/VBA-Web or https://www.guru99.com/excel-vba-selenium.html

TimHall's VBA-Web

https://github.com/VBA-tools/VBA-Web has quite some interesting code that helps to connect to APIs.

There is a very excellent VBA library VBA-web that can be used to connect to HTTP APIs and collect the data from them.

GitHub - VBA-tools/VBA-Web: VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web