Get Drive name

[Shark]

How do you get the drive name.

example= \\Host1\whatever

[1 is a prime!]

You could use the App.Path command:
This gives the full position of the current application within the file structure, as a string.

Test it using: debug.print app.path

Just use the left command to get the bit you want:

driveletter = left(app.path,1)

Hope this is what you want.

Cheers,

Steve.