I have a excel workbook that creates a nice graphical reports from data it pulls in via a query from an MS ACCESS DB.
I would like to create the ability for the end user to change the data source where they would type the connection string into a cell and have a VBA button click injected it into the Connections string.
something like this:
Sheets(1).Range("A1") would have this:Please Login or Register to view this content.
"DSN=MS Access Database;DBQ=\\Domain\Folder\SubFolder\Live DB\AccessDB.accdb;DefaultDir=\\Domain\Folder\SubFolder\Live DB;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
I have exhausted my online search for a solution and I'm hopeful that someone here can point me in the right direction.
Thanks for your help
Bookmarks