There are several things you can do to make you application more dynamic. But, in the interest of time I can only answer the one question you had. The application path or the path of the current exe as you put it can be retrieved from the the os using the App.Path() funtion in VB
The application object has many members one of them is the Path. This will return the path where the application exe is located and running.
Dim strCurrentPath as String
strCurrentPath = App.Path
Give it a try. The other thoughts I have involve testing the drive using the File System Object, or using a registry setting or ini file. These can all make you application more dynamic. You can read more about the File System Object in the MDSN files - On line help.
Hope this helps.