Hello,

Currently I am using the following line of code to specify the location of
my database.

MyConn = "S:\Mydatabase.mdb"

Instead of hard coding the location of my database, I would like to enter
the location in Cell A1 in Sheet2. How do I change this line of code so it
would read the location of my database from whatever I type into cell A1 in
Sheet2?

Thanks!