myConn = activeworkbook.worksheets("sheet2").range("a1").va lue

Activeworkbook
could be
ThisWorkbook
if the that worksheet is in the same workbook with the code.

Or even
workbooks("myotherworkbook.xls").worksheets("sheet 2").range("a1").value



jojo wrote:

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!

--

Dave Peterson