I'm obviously just starting out with VBA too, and we were all talking about ways to connect VBA and datasets stored in MS SQL Server so that we pull data sheets automatically. I'm just confused, cos I have heard the terms ADO, DAO, and ODBC before. Can anyone explain how all these components work together / describe what they are?
Also, how do you know when it is a necessity to pass an argument byVal instead of ByRef? I'm all lost in the semantics at this point, and just need to understand these so I know when to apply them.
Thanks for all the help!