You could also define this information in the Visual Basic code that specifies the connection string. Commonly, you can create the DSN with the ODBC Data Source Administrator, which you can access ...

Visual Basic for Applications (VBA) is a programming language embedded in Microsoft Office that can be used to automate processes and build functions.