The "SCHOLARS" you seek are smart enough to see one post. They don't need 3. All posts here are important to the person posting it. Most are urgent requests caused by some business request. This board is a community that gives answers to people who have attempted to program a specific task and are stuck.
Once installed, new components, like MysqlDataset and MysqlDataTable, will appear in your toolbox in visual studio. Documentation on how to use them should also be included in the download, otherwise you can lookup the documentation for the ADO.NET components, like Dataset and DataTable, in the visual studio documentation, they are used the same way.
If I use tlbexp I get only my class exposed, but not my methods. Any ideas? (I suppose, the methods have to have a certain format.)
Nevertheless I do not belive, that a COM-object is the only way to get a connection to VBA. With a COM-object you do not need a Declare Function statement. But with a Declare Function one can access all routines eg. in the kernel.dll. (And that are not COM's in kernel.dll).