If I was using code to refer to a file's location say "E:\files\1.doc" is there a way I can copy that 1.doc into the project folder and code it so the program will find it no matter where the project folder is without having to add the document as a resource...

I know when referring to databases you can use -

Dim ConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Users.mdb"

The part I suspect I need being -

|DataDirectory|\Users.mdb"

Thanks for any help, Robin