Creating Db Connection At Runtime 追蹤
I use Access and Bartender in many of my Excel macros. I am able to build a connection string for the Access db based upon the workbook path. For example:
ConnStrg = "provider=microsoft.ACE.OLEDB.12.0;data source=" & ThisWorkbook.Path
ConnStrg = ConnStrg & "\ReorderDB.accdb;persist security info=false;"
I would like to do the same for Bartender, that is create the format database connection at runtime. Any suggestions?