ADODB connection - Changing connection path via fileDialog

Hello,

I use the following code to create a connection to another workbook.
But what if I want the user to be able to choose which workbook he or she needs to connect to?

I want "strDBPath = "P:\SE\AVK\C. Projektmodell\Pärmen\APL\APL.xlsx" to be equal to the file the user chooses form a filedialog.

Anyone know if this is possible?


Thanks!

Please Login or Register  to view this content.

strDBPath = Inputbox("Enter the database path"),

This will open up a box where the user can paste the required path which gets saved for the same variable strDBPath