Hi all,
Allt Svar (1)
Hi Christian!
Funny story, SuperOffice (Windows App) onsite used to have an embedded VBA engine (COM) that ran scripts in the client based on user activity/events.
You didn't state online or onsite, so I'll just assume onsite for now. Sure, you can use VBA code to call SuperOffice API's, but there's the security hurdle that you have to get around. It's not safe or secure to tuck credentials in VBA code, so as long as you can securely get access to a supported form of credentials, then you could access the APIs. As for direct Database access, well then again yes, assuming you have credentials that can get your in the database server and instance, you would wind up using ADO classes for direct SQL calls.
You didn't state a use case, so assuming it's for Excel, this example demonstrates how to populate an Excel spreadsheet using Basic credentials (not safe or secure, but possible).
If you share your use-case I'm confident this question would garner more responses based on the similar experiences in the community.
Best regards!