Hi,
I have a excel sheet that exports data in a db in the same folder that it is in. How do I set up the connection to the db without completely entering in the path.
right now I have
Set db = New ADODB.Connection
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = \Copy of TEST2.mdb;"
I can't just set the path because I have to put this db on the newtwork, and different will map it with different drives to get access. But I don't remember the syntax for opening the db in the same folder.
Thanks
Emily