So what i'd like to do is link a database to a GUI that people can easily add information into the database. The next step is to get that information and populate it into Microsoft office documents such as word, excel, powerpoint etc. And create folder structures within Windows (or the cloud, but not too sure about that at the moment because I can't seem to find anything with large enough business storage).
At the moment I am just using VBA within excel and word to pull the data from the database and also VBA to create the folder structures. To enter the data, this is just done within the database itself (we are using airtable, although previously I used mySQL and had the data entered in via a userform and VBA.) The problem with the VBA is that if you can access the code, you can find the API key and password. Is there anyway you can hide this like you can with frontend/backend type arrangements?
Probably a bit rambly, but any help or follow up questions much appreciated!
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)