File Locations

[pr4t3ek]

Hi,
I use the below code to specify where a database is:

myDB = "C:\Documents and Settings\Pratik\Desktop\Testdb.mdb"

I was wondering if there was a way to amend this for it to just look on this PC/User's desktop without my actually specifying the actual path?

Maybe something like..

Application.Desktop

or something??

I need this because i'm potentially going to send this code to other user's and get them to run this macro...

[mudraker]

Try

myDB = Environ("USERPROFILE") & "\desktop\Testdb.mdb"

[pr4t3ek]

excellent, cheers!