How do you get the drive name.
example= \\Host1\whatever
Printable View
How do you get the drive name.
example= \\Host1\whatever
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.